mtillman-921105 (12/14/2010)
Good question - thanks! NULLs can be hazardous, they should come with a warning.
In the case of "Null value is eliminated by an aggregate or other SET operation" the trick is to use nulls without the warning.
hint: set ANSI_WARNINGS OFF (and accept responsibility for the consequences)