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