>Is there a way to make a temp table created by SELECT INTO with a dynamic sql statement visible to other non-dynmaic sql statements?

Hi John,

You can create a global temporary table (##Temptable) but it'll be visible to all sessions.