Home Forums SQL Server 7,2000 T-SQL Null value is eliminated by an aggregate or other SET operation. RE: Null value is eliminated by an aggregate or other SET operation.

  • July 15, 2008 at 2:35 pm

    #843411

    This is not an error message. SS2K is simply telling you that it ignore NULL values when performing an aggregate operation on records.

    Such as

    5, NULL, 7

    SUM will produce the result 12 WITH the warning message.

    Anything added, subtracted, etc. to NULL yields in NULL. 5 + NULL + 7 --> NULL.

    You could filter out the NULL values before calling the aggregate.

    Regards