Moral of the story is...

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #131,264 by ChrisR 12/17/03 4:55:36 PM Reply	Moral of the story is... ...don't use SELECT INTO in SQLServer. You listed a couple of the reasons, but there are some others as well. Just do a CREATE TABLE #temp and then insert the recordset into the temp tables. Better yet, use a TABLE VARIABLE and avoid the transactions overhead.
Post #131,344 by mmoffitt 12/18/03 9:49:39 AM Reply	What he said. bcnu, Mikem Java, Junk. Both start with a "J", both have four letters. Coincidence? I think not.

SQL/Server rant for the day - (broomberg) - (5) - Dec. 17, 2003, 04:52:44 PM EST

Moral of the story is... - (ChrisR) - (1) - Dec. 17, 2003, 04:55:36 PM EST

What he said. -NT - (mmoffitt) - Dec. 18, 2003, 09:49:39 AM EST

Won't it be interesting when... - (FuManChu) - Dec. 17, 2003, 05:25:05 PM EST

Yet again MS show a single-user mentality. - (static) - (1) - Dec. 19, 2003, 05:00:05 AM EST

No choice - (deSitter) - Dec. 19, 2003, 06:19:01 AM EST

Jung would have wanted it this way.
64 ms