Eugene Elutin (11/14/2012)
I wouldn't call it "personal preference". It's wrong type of join, which can lead to worse performance.
That is exactly what INNER JOIN is for, so better to be written as
My preference I meant was to conditional check, I did point out that it should be an inner join.
The personal preference was to use
where mas.Plant_CD is NOT NULL
instead of
where NOT(mas.Plant_CD is NULL)
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/