thomashohner (7/18/2014)
Also they do several calculations in the WHERE clause. Also a bunch of this " IS NULL OR""Thanks for your answer that's exactly what I was looking for!
Glad to help. 🙂
Something else to look into, especially if you're used to a different platform, is how to deal with your IS NULL OR components. They're colloqually known as 'catch all queries', and you might want to browse this technique to deal with them by Gail Shaw:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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