I have explored the use of #Temp, doing an insert on that table takes about 4 secs. for about 11000 rows.  However, when I attempt to query up any data that is in #temp from another SP I get no results.

The nested SPs may be an option, but I can not find any examples of how to do this.  Everything that I find just reiterates what Books online says.  (Not much).

Can someone post an example of a nesting Stored Procedures or point me in the right direction?

Thanks