Billy Pang
tuxedo_man at hotmail.com
Tue Aug 19 18:58:38 CDT 2003
Ok. Thanks. It is possible to monitor the occurance of this warning message from Profiler? Thanks in advance, Billy >From: "Djabarov, Robert" <Robert.Djabarov at usaa.com> >Reply-To: dba-sqlserver at databaseadvisors.com >To: <dba-sqlserver at databaseadvisors.com> >Subject: RE: [dba-SQLServer]How to suppress this warning message? >Date: Tue, 19 Aug 2003 10:04:40 -0500 > >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 > > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus