Home Forums SQL Server 2008 T-SQL (SS2K8) Warning: Null value is eliminated by an aggregate or other SET operation. RE: Warning: Null value is eliminated by an aggregate or other SET operation.

  • February 7, 2012 at 2:52 am

    #1443610

    The problem is there are no null values in T2.Columnname2 as such. But since it is left joined with T1, there are some null records as a result of this. So if I use count(isnull(T2.Columnname2,0)), the count will not be correct.