cafescott (11/29/2011)
I'm using select-into rather than insert-into because I don't have a good idea what the table structure is. The select statement is huge, and it is much easier to do a select-into.
I would explicitly create the table.
You should be able to easily identify what the structure is and you will have better control if you use an INSERT INTO.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/