RE: Omit record from SQL AVG based on field value

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

You were right, this really is too much for a Friday afternoon.

I used Chris's method and realized that the differences were all
negative and I've been doing the subtraction backwards all this time.
That's why the case wouldn't work like I wanted it to.

Let's see if I can figure it out now.

Thanks,

Rick

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
> Sent: Friday, February 02, 2007 2:22 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Omit record from SQL AVG based on field value
>
> There is nothing syntactically or logically wrong with your statement.
> Make sure locftst is greater than locbtst in some of the rows
> at least.
>
> 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.