[font="Comic Sans MS"]Unless I managed to mangle the code while trying to make it more readable, this is the section that causes the difference between the two results sets.

I'll look...

[font="Comic Sans MS"]The script given by Mr. Serres applied to my CRM database returns 5923 ROWS.

The original script by Mr. Khan returned 6504 ROWS.

Given the number of rows, it is...

Apart from the fact that I needed this 4 years ago, excellent article.

[font="Comic Sans MS"]

I am NOT saying or implying that this o.p. falls into the category I am describing below (he clearly does not because he was asking for guidance on...

[font="Comic Sans MS"]What would prevent a user from scripting all stored procs and views in a common file and then just use a text editor to find and re-place the...

[font="Comic Sans MS"]Actually I would prefer to know the LAST TIME the procedure was run and by whom, in order to determine which ones have become unused fossils.

Any plans to...

[font="Comic Sans MS"]So the optimizer IS actually using the equivalent from Boolean algebra ?[/font]

As I wrote before:

[font="Courier New"]WHERE NOT (ProductID = 1 OR ProductID = 2 OR ProductID = 3...

[font="Comic Sans MS"]You are right about the choice of word "failing". It works in its own way, not the according to what I expected.[/font]

[font="Comic Sans MS"]Still I am curious as...

[font="Comic Sans MS"]Thank you all for your inputs, I now understand what INTERSECT and EXCEPT bring to the party.

I am however still trying to understand why the following occurs:[/font]

[font="Comic Sans...

Thank you Nevyn

Now THIS was the exact answer I was looking for.

The article you referred to did not really go much beyond what I started with.

Thanks a million for drawing...

You are right, I really meant INTERSECT only.

EXCEPT was a mistake. (Also, [font="Courier New"]SELECT ProductID FROM Product WHERE NOT ProductID IN (SELECT ProductID FROM WorkOrder)[/font] also does yield the same...

Should not Server Central also take care of this

http://www.sqlservercentral.com/Authors/Articles/Kamil_Moscicki/1531761/

Guest Columnist: Kamil Moscicki

-> btcmalls74

NO SPAM

I would not worry about people complaining on the amount of effort required to provide the information required to solve - for free - their problem. If it is not...