Get results into table from dynamic tsql

To generate a temporary table dynamically without specificng the structure up front, use the SELECT INTO syntax

select col1, col2, col3
into #YourTempTable
from AnotherTable

The datatypes will be determined by the base datatypes in the source tables (or expressions if an explicit convert is done)

When you say "dynamic query results", I assume you mean the results from a string containing sql, that you execute with EXECUTE('select * from someTable') If that's the case, you have only one option that I can think of: Use a global temporary table.

Like this:

EXECUTE('SELECT * INTO ##t FROM someTable')

Then you can use the global temporary table in your code. Like this:

SELECT * FROM ##t

The problem with this solution is that the temporary table you create is global. It will cause problems in a multi-user environment, if this is run by two users at the (more or less) same time the SELECT INTO will fail since the table already exists.