Dynamics 365 MVP
Friday, August 04, 2006
Using Select into in Sql server
It's a No No
Don’t use select into as it locks the tempdb for the duration of the select. You have to create the temp table fist and then do a insert … select … from. Need to look at it this in SQL 2005.
Joe Gill - MVP Dynamics CRM