Check out example codes for "sql server: creating temp table by selecting records from other tables". It will help you in understanding the concepts better.

Code Example 1

SELECT *
INTO #<Temp_Table_Name>
FROM <TableName>
WHERE <Conditions>
ORDER BY <Col_Names OrderSeq>
OPTION <Options>

Code Example 2

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

Learn ReactJs, React Native from akashmittal.com