Re: Warning Message for SET Operation

From: Sadeesh[MSFT] (sadeeshp_at_online.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 16:40:06 +0800

Hi

Check this article

http://support.microsoft.com/?id=317312

HTH

Regards
Sadeesh 

-- 
This posting is provided AS IS with no warranties, and confers no rights.
"Peter" <anonymous@discussions.microsoft.com> wrote in message 
news:1d3701c46fb5$ead2be20$a301280a@phx.gbl...
> When I run the following script,
>
> SET m_date = (select max(t1.cdate) ...
>
> I get an error message:
> "Null value is eliminated by an aggregate or other SET
> operation."
>
> I just wonder why I encounter this warning message. It
> should apply to AVG / SUM but why also to MAX ?  Can I
> just ignore it ?

Relevant Pages