Warning:Null value is eliminated by an aggregate or other set operation

[Mittle]

Hi-
I am getting the desired number of records when I run my query but getting the all common warning message
Warning:Null value is eliminated by an aggregate or other set operation

Could someone please advise what can be done to this warning message that appears

is this something that can be gotten rid of ?



Thanks

 

[Minty]

You can get rid of it at a database level

SET ANSI_WARNINGS OFF
GO

There is more here sometimes you may want to see such warnings

SQL SERVER - Warning: Null value is Eliminated by an Aggregate or Other SET Operation - SQL Authority with Pinal Dave

Working with NULL’s are always a challenge – not many developers understand how NULL works sometimes. In a related note, long back I wrote below blog in

blog.sqlauthority.com

 

[Mittle]

Thanks Minty for responding.

its a bit tricky though as cant use it in a view script and save ok .it disappears once the view is created .

have you had instances where you have had to turn this setting off at the database level though

 

[Minty]

No, not personally - according to the blurb it is turned off by default, but I find that a bit odd.

I assume when you connect to the view through Access the warning has no effect?

 

[Mittle]

ok thank you not sure what to do next . . the warning message comes up in Management studio.not sure whether it will come up at the front end .will see if anyone else has some workaround

No the users will be connecting to SQL Server via tableau not access. we are getting rid of access once migration is complete.

 

[Minty]

From memory, if the view/SP returns records without an actual error the message will be ignored.