So, double check one more time...

All indexes (indluding primary keys) on the test box are also available on the production box.

All tables have the same row count on both boxes.

All...

You didn't listen to me... lookup "expanding hierarchies" in Books Online and adapt it. It WILL do as you ask.

Oh, little nuances like will there ever be more than 2 names in a class? If so, do all the scores have to be the same or just 2?...

Yes, there's an easy way to do the whole thing... without a loop. The loop is just going to make this very slow...

Recommend you post your code and let's...

And, to be sure, it DOES matter where you put the filters in the case of an OUTER JOIN.

I think you're gonna need to be a bit more specific in your question... I for one, have no idea what your question is actually about.

Activity counts, basically...

Something like 1 point per post, 1 or 2 points per script (not sure there), etc.

Notice that these are also migrated from the "old" format of the forum...

I don't think so, but links are sometimes a bit picky. If you don't find any other problem, I think I'd set up a small test to make sure.

Add an IDENTITY column to the table with the correct seed...

Heh... yeah, agreed... I've seen folks destroy production with an UPDATE as well... but it was never with the proper form of update (like Greg's is) which must be "If...

What...

Thanks for the rowcount and line size... I've got an experiment or two to do... I'll be back...

Matt Miller (11/9/2007)

---

If it's a process THIS expensive, you should consider making this a permanent table. Meaning - keep the existing table just as it is, and have another...

I think you're going to find that the problem is a bad date in the Oracle view. Check for any dates there that are outside the range of '17530101'...

Not true, Sergiy... and if you look, although it works, UPDATE tablealias isn't even listed in 2k BOL...

Syntax

UPDATE

{

...