Privet Sergey...

I tried that in the select into and it still errored out at the call to use it non-dynamically.

Are you saying to create the table non-dynamic, use the dynamic sql to populate it, then use it?



>>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.