RE: Omit record from SQL AVG based on field value

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

Elvis,

I thought about using case to replace bad values with null but that will
still include the record in the count won't it?  Or, does it keep a
separate count of occurrences by field?  Maybe I'm making this harder
than it is.

Rick

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
> Sent: Friday, February 02, 2007 1:35 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Omit record from SQL AVG based on field value
>
> Rick, I don't know where to start with your SQL statement,
> it's too much work for Friday afternoon :(
>
> I do believe that what you need is to simply ignore the
> fields where you have no values by casting them to NULLs. 
> You do this with CASE clause.
> I googled and found this link that illustrates the point:
>
> http://www.craigsmullins.com/ssu_0899.htm
>
> See SQL statement #3.
>
> If you can simplify your statement or at least narrow down
> the problem, post back.
>
> Elvis
>
> Celebrating 10-Years of SQL Performance Excellence

Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.