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

{

...

Heh... or, you could just shoot yourself in the head now and save on the anticipation 😀

Heh... no problem there... most people don't even know it exists! 😛

Thanks for the feedback, Bruce.

Heh... also notice that the != gets converted to a <> in the query plan output 😉