Duh, don't I feel dumb... :-) Thanks so much Tim, worked perfectly.
John -----Original Message----- From: Raster, Tim [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:27 AM To: SQL Subject: RE: selecting from calculated group SELECT HourlyWageBefore/HourlyWage*100 AS PercentageReplaced FROM dbo.Enrollments WHERE EnrollmentDate BETWEEN '#form.fromdate#' AND '#form.todate#' AND HourlyWage > 0 AND Siteid = #SiteID# And HourlyWageBefore/HourlyWage*100 > 90 -----Original Message----- From: Venable, John [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 09:24 To: SQL Subject: selecting from calculated group Hello everyone, I'm trying to get the number of people who got >=90% of the previous salary when they got a new job. I can get the percentages from the query below, I cannot however figure out how to put "WHERE PercentageReplaced >= 90" Any way to do this in a single query or a sproc? SELECT (HourlyWageBefore/HourlyWage*100) AS PercentageReplaced FROM dbo.Enrollments WHERE EnrollmentDate BETWEEN '#form.fromdate#' AND '#form.todate#' AND HourlyWage > 0 AND Siteid = #SiteID# Thanks, john --- John Venable Director of Web Architecture Epilepsy Foundation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1672 Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
