In Microsoft SQL server, I&#039m trying to create a two step stored procedure for an application. Step 1 pulls information from 4 different tables, filters, combines, groups, adds several calculated fields, and leaves the results in a temp table. Step 2 then runs selecting only a handfull of fields from the results. What I have run into, is that any temp tables created by Step 1, vanish when Step 1 finishes and before Step 2 is run. I can&#039t use a fixed table name because what if multiple users hit at the same time and both try to filter on the same table. I can&#039t use a passed parameter as a unique table name (such as sessionID from IIS). How can a I make the data persist long enough to perfom the second select statement?