No you cannot. temp tables created using #table_name are only available to that session and when you end step 1 and start step 2 sessions change. You could use a global temp table using ##table_name, but you would need to explicitly drop it when you are down with it. You could also combine the 2 steps into one and use the temp table or create a real table that you purge as step 3.