insert the result of a query into a temporary table code example

Example: select into temp table

SELECT t.col1, t.col2...
INTO #temp
FROM table1 AS t