It basically creates a new table with the data from a another table. See example

USE AdventureWorks

GO

----Create new table and insert into table using SELECT INSERT

SELECT FirstName, LastName

INTO TestTable

FROM Person.Contact

WHERE EmailPromotion...

Check this link for an explanation

http://blog.sqlauthority.com/2007/08/15/sql-server-insert-data-from-one-table-to-another-table-insert-into-select-select-into-table/

SELECT INTO

This method is used when table is not created earlier and needs to be created when data from one table is...

Hi,

Try this and let me know if it works;

,Test1<ctrl>

,Test2<ctrl>

IF OBJECT_ID('tempdb..#TEMP') IS NOT NULL

DROP TABLE #TEMP

CREATE TABLE #TEMP

(

...