CREATE TABLE #haro_products ( product_name VARCHAR(MAX), list_price DEC(10,2) );
SELECT * INTO #<Temp_Table_Name> FROM <TableName> WHERE <Conditions> ORDER BY <Col_Names OrderSeq> OPTION <Options>