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?