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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Message: http://www.houseoffusion.com/lists.cfm?link=i:6:1670
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:>
