RE: Omit record from SQL AVG based on field value

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.