Inserting data into a temporary table

sql sql-server temp-tables

INSERT INTO #TempTable (ID, Date, Name) SELECT id, date, name FROM physical_table

sql sql-server temp-tables

To insert all data from all columns, just use this:

SELECT * INTO #TempTableFROM OriginalTable

Don't forget to DROP the temporary table after you have finished with it and before you try creating it again:

DROP TABLE #TempTable

sql sql-server temp-tables

SELECT  ID , Date , Name into #temp from [TableName]

CodeHunter