User Rating!

Home > Search > Knowledge Base > SQL Server > Bugs and Fixes > Bugs and Fixes

PRB: Unexpected Warning About Eliminating NULLs from Aggregate (Q317312)

Total Hits: 1970  |  Today: 0       Rating:

Read Reviews | Write Review | Your Rating:  Select One 5 Stars - Best Rating 4 Stars 3 Stars 2 Stars 1 Star - Worst Rating

If you run a query that contains an aggregate function in the subquery, and if the subquery returns a non-NULL column, it may be possible for the query as a whole to generate the following warning message:Msg 8153 Warning: Null value is eliminated by an aggregate or other SET operation.

DevASP.Net users Rating What is your opinion? 5 Stars4 Stars3 Stars2 Stars1 Star

Is this your listing?

If this is your listing and you like to add the rating box
displayed on the right side on your site you can use the following code.