Insert into create new table

sql database tsql insert

SELECT top 0 *INTO NewTableFROM BigTable1    CROSS JOIN BigTable2

sql database tsql insert

For T-SQL,

SELECT ...INTO MyTableFROM ...

sql database tsql insert

You can use a SELECT INTO TSQL query - see MSDN link.

CodeHunter