Viewing 12 posts - 7,471 through 7,483 (of 7,483 total)
J (11/6/2008)
No. YOU ARE wrong.
It does not matter if there are duplicates or not, because the question specifically mentioned that there were no duplicates.
So "UNION ALL"...
Tom
January 26, 2009 at 2:49 pm
For SQL 2000 (and the question explicitly includes "before SQL 2005") there is no way of specifying ignore_dup_key for a primary key. Any attempt to specify "with ignore_dup_key" in...
Tom
January 26, 2009 at 2:44 pm
It threw me. I assumed SSMS would behave the same way as isqlw so gave the wrong answer. I'm inclined to consider the SMSS behaviour a bug, as making...
Tom
January 26, 2009 at 1:03 pm
Piotr Rodak (11/22/2008)
The Hash Match operator that is used whenoption (hash union)is used apparently sorts data anyway, just NULLs are added to the end of the output.Piotr
The hash...
Tom
January 26, 2009 at 11:55 am
TheSQLGuru (1/6/2009)
.... here is a quickie example. as the number of rows (or joins) goes up it gets much worse
....
This example may be rather misleading, depending on...
Tom
January 6, 2009 at 1:48 pm
Matt Whitfield (1/6/2009)
Tom
January 6, 2009 at 5:19 am
David McKinney (1/2/2009)
ANY SOLUTION based on sysdepends isn't going to work.
The obvious solution based on sysdepends - running alterproc for the SP with no changes before using sysdepends - works...
Tom
January 2, 2009 at 1:43 pm
TheSQLGuru (1/2/2009)
1) Tom, can you or anyone else give an example of UPDATEs that cannot be done without using the FROM clause that can be done with it's use?
2) I...
Tom
January 2, 2009 at 12:09 pm
Jeff Moden (1/1/2009)
npfitzner (1/1/2009)
Tom.Thomson (1/1/2009)
He wants to remove the From clause from the Update statement? Seriously?No - I think that's what the 😉 was for.
🙂
Yes! ...
Tom
January 2, 2009 at 5:57 am
Jeff Moden (12/31/2008)
Tom
January 1, 2009 at 11:28 am
In my previous post please substitute "or" fro "and" in "FAST_FORWARD and STATIC". Tom.
Tom
December 31, 2008 at 5:28 am
Just add "FAST_FORWARD" and "STATIC" to the cursor definition and the cursor method will run as fast as your non-cursor method (and for large datasets it will probably...
Tom
December 31, 2008 at 5:15 am
Viewing 12 posts - 7,471 through 7,483 (of 7,483 total)