SQL Kiwi (8/22/2012)
There is a better, and easier way to do it using NOT EXISTS and INTERSECT. I describe the technique here: http://bit.ly/EqualityComparison
That. Is. AWESOME.
I stand humbly corrected, thanks for bringing this to the table Paul. I believe I have a query (or 10) to mark for modification once we get out of 2k5. Thanks again!
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA