select * tom temp table code example

Example: select into temp table

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