Post reply

What is this warning

  • July 12, 2004 at 11:25 am

    #152221

    can any body tell be about this warning.

    what it is any why it comes

    Null value is eliminated by an aggregate or other SET operation.

    Thanks

  • July 12, 2004 at 1:01 pm

    #514303

    When you use an aggregate function, the null values in the columns are ignored.

    eg: Avg(Price), if Price column has a null, it is ignored

  • July 12, 2004 at 3:40 pm

    #514311

    Thanks

  • July 13, 2004 at 10:34 am

    #514426

    If the warning is causing problems, just do an "Is not Null" on the Aggrated value in the where clause. I know some .asp code really does not like warning messages very much. Some times the page will think there was an error, so you have to get rid of the warnings.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply