Anyone know if you can execute a stored procedure within another stored procedure / query??

Trying to do this

SELECT .........

WHERE (COMPANY_ID NOT IN (SELECT..........)

I want the NOT IN Query to be stored as a seperate procedure/query

I can do it in access I know but I need to do it in Transact-SQL