Q:

select into temp table

SELECT t.col1, t.col2...
INTO #temp
FROM table1 AS t
0
SELECT * 
INTO #temp
FROM (
    SELECT col1, col2
    FROM table1
) AS x
-1

New to Communities?

Join the community