Warning: Null value is eliminated by an aggregate or other S

Question

Warning: Null value is eliminated by an aggregate or other SET operation while i am running my sp i am getting this warnimg . wat should i do? any one canhelp plsss

Vinay Singh · Answer

I dont think so it will cause problem. As we know when we perform some maths operation we need some number and in case of sql of sql if the field is null then it will consider the value as 0 and then execute it. For detail check the link http://blog.sqlauthority.com/2015/02/13/sql-server-warning-null-value-is-eliminated-by-an-aggregate-or-other-set-operation/ http://stackoverflow.com/questions/18719436/getting-warning-null-value-is-eliminated-by-an-aggregate-or-other-set-operation http://stackoverflow.com/questions/11384292/warning-null-value-is-eliminated-by-an-aggregate-or-other-set-operation-in-aqua

ali tuncer · Answer

if you want to turn off that message you can run this before your script SET ANSI_WARNINGS OFF GO I don't think this warning will cause serious issues. Check here for details: http://blog.sqlauthority.com/2015/02/13/sql-server-warning-null-value-is-eliminated-by-an-aggregate-or-other-set-operation/