An interesting question. They may be treated differently depending on whether the nullable field is one of the grouping fields, or is one of the selected aggre

An interesting question. They may be treated differently depending on whether the nullable field is one of the grouping fields, or is one of the selected aggregate fields. https://blog.sqlauthority.com/2015/02/13/sql-server-warning-null-value-is-eliminated-by-an-aggregate-or-other-set-operation/?amp https://blog.sqlauthority.com/2015/02/13/sql-server-warning-...