How to Off Warnings Message in Execute the View Query

Question

0.00/5 (No votes)

See more:

Hi,
I am Execute The View Query But Give "Warning: Null value is eliminated by an aggregate or other SET operation." But not affected data so how to stop warning messages
in view Please tell me the any functions. I am using "Set_Ansi_warning off" But this not worked because this is view.

thans & Regards
raju

Posted 20-Feb-13 22:54pm

s v b raju

Updated 20-Feb-13 23:00pm

v2

Add a Solution

Comments

CHill60 21-Feb-13 11:04am

Please post your query - it's better to fix the problem then turn off messages

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Khorshed Alam, Dhaka · Answer 1 · 2013-02-21T05:00:00

As you did not provide any code snippet I think your query could be like below

SQL

SELECT COUNT([uid]) AS [new_count]
FROM   [Users]

This above query will produce the warning if any column of the table contains null value. Better to write the query like below

SQL

SELECT COUNT(CASE WHEN [uid] IS NULL THEN 0 ELSE 1 END) AS [new_count]
FROM   [Users]

Hope this will solve your issue.