"now and not multiple queries that have to researched and changed. I use this technique quite often and it often forces me to use a temporary table to hold the results of those stored procedures since Transact-SQL does not allow the results of a stored procedure to be used as a table"

Have you considered using table valued fucntions instead? This would allow modular code without forcing you to use temp tables.

What you think?