MSSQL - Create temp table from select query result

Watch this example on YouTube



Select *
Into #TempProduct
From Product

Select * From #TempProduct