If you have TempDB set up to auto-grow by 10% like everyone else seems to, it will cause 73 fragments as it grows to 1 gig. And, I agree...

Just so you know... Books Online comes with SQL...

The beating is better...

If the code must ever be executed more than once, it will fail because the tables in the two or more instances of the proc will be...

Didn't look that way to me,...

What do you use SQL Server 2000, instead?

Yeaup, we all need rules... but to keep from becoming a non-thinking "SQL Clone", ya gotta read about the "5 Monkeys Experiment"... you'll see what I mean... 😉

http://www.lanebaldwin.com/v03I8.htm

Dunno if there's...

If you use the extra parameter I posted in 2k or 2k5, it will also...

Maybe not in SQL Server 7 because of the...

Yes... and sorry I missed that... I verified that Store_key was the same in both tables and didn't even look Orig_Store_key.

That's pretty cool... Thanks, Rob...

Carl Federl (1/7/2008)

---

"f I am understanding what you wrote then the solution is truly laughable from a performance (and coding) standpoint!! You have to create two tables and populate them...

Andrew Whettam (1/6/2008)

---

Oracle objects can be given Mixed Case names by using quotes when creating them e.g. "MyTableName". This seems to be frowned upon in the Oracle community -...

No, no... it's not that... in SQL Server, you have a Deleted and Inserted table... in Oracle, they are not tables... they are essentially variables that contain 1 row... you...

Heh... I'm confused... I recommended generic names, not DATABASE_MODULE_TABLE...

I see that... and it still comes out at just "which scripting language does...".

The other thing is, you should never rely just on the title of a post to convey...