CODEWITHSUNDEEP
sqlsql-serverexcel
Anuj Yadav
Anuj Yadav

Reputation: 39

How to get data from SQL To excel

My sql query is running fine but when I export the data to excel it gives warning : null value is eliminated by an aggregate or other SET operation. How to fix this issue?

Upvotes: 1

Views: 104

Answers (1)

Serg
Serg

Reputation: 22811

Really it's just a warning indicating some aggregated data are NULLs. For example average of {10, null, 20} is (10+20)/2=15, null is totally ignored. If it's OK, just ignore the warning or set ansi_warnings off to turn it off. Otherwise check your data for NULLs or change the query accordingly.

Upvotes: 4

Related Questions