Hi,

I would like to get the results of three different queries and put them all into one temp table. I am trying as follows but does not seem to be working. Is there a better way to do this?

INSERT INTO #Temp

EXECUTE sp_executesql @SQL

EXECUTE sp_executesql @SQL2

EXECUTE sp_executesql @SQL3