[dba-SQLServer]How to suppress this warning message?

Djabarov, Robert Robert.Djabarov at usaa.com
Tue Aug 19 10:04:40 CDT 2003


If you're getting this error after a query (S/I/U/D), then identify the
field that is being aggregated and do an ISNUL(..., 0) prior to
aggregating it, like this: SUM(isnull(<your_field>, 0))

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy
Pang
Sent: Monday, August 18, 2003 6:04 PM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]How to suppress this warning message?


"Warning: Null value is eliminated by an aggregate or other SET
operation."

Is there a way of suppressing this warning message?

Thanks in advance,
Billy

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list