I have an <exec(@query)> command the executes a character string and returns a table. I want to select from the results, or simply define it as a temporary table. I can't use openrowset (because of highly restrictive server settings).
How do I do this? Isn't it as simple as
select * into #temp2 from (exec(@query))
? Or am I missing something. I am a newbie so be gentle.
View Complete Post