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:1671
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:>
