select into temp table tsql code example

Example 1: tsql create temp table

CREATE TABLE #haro_products (
    product_name VARCHAR(MAX),
    list_price DEC(10,2)
);

Example 2: select into temp table

SELECT * 
INTO #temp
FROM (
    SELECT col1, col2
    FROM table1
) AS x