Phil Parkin (6/28/2016)
I still prefer the EXCEPT or INTERSECT versions, because of their inherent handling of NULLs & agree that the EXCEPT form is possibly more pleasing on the brain than the NOT EXISTS ... INTERSECT form.
That's your personal preferences, and you have every right to have it and follow it (unless you're in North Korea :-))
Functionally all 3 methods are the same, so it's other factors which play role in choosing one method over another.
Like with CTE - I prefer to use derived tables, some prefer CTE's, and neither side has a case to prove which method is better.
_____________
Code for TallyGenerator