Viewing 15 posts - 54,181 through 54,195 (of 59,065 total)
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...
November 11, 2007 at 6:55 am
And, to be sure, it DOES matter where you put the filters in the case of an OUTER JOIN.
November 11, 2007 at 6:52 am
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.
November 11, 2007 at 6:31 am
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...
November 11, 2007 at 6:29 am
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.
November 11, 2007 at 5:44 am
Add an IDENTITY column to the table with the correct seed...
November 10, 2007 at 12:15 pm
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...
November 10, 2007 at 8:22 am
Bob Fazio (11/2/2007)
I forgot to add.If you have several queries (which most people do) create an index based upon the more common set of those fields.
What...
November 10, 2007 at 8:01 am
Thanks for the rowcount and line size... I've got an experiment or two to do... I'll be back...
November 10, 2007 at 7:37 am
Matt Miller (11/9/2007)
November 9, 2007 at 10:37 pm
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'...
November 9, 2007 at 9:23 pm
Not true, Sergiy... and if you look, although it works, UPDATE tablealias isn't even listed in 2k BOL...
Syntax
UPDATE
{
...
November 9, 2007 at 5:55 pm
Heh... or, you could just shoot yourself in the head now and save on the anticipation 😀
November 9, 2007 at 5:23 pm
Heh... no problem there... most people don't even know it exists! 😛
Thanks for the feedback, Bruce.
November 9, 2007 at 5:13 pm
Heh... also notice that the != gets converted to a <> in the query plan output 😉
November 9, 2007 at 5:07 pm
Viewing 15 posts - 54,181 through 54,195 (of 59,065 total)