cv304
9/8/2017 - 4:46 PM

Wage rate from Employee Base

This one was posted by Jenn Goodwin a couple of months back.

https://www.linkedin.com/groups/1276507/1276507-6016308904537923584

SELECT TOP 1 ewRegularPayRate
FROM AxEmployeeWage
WHERE ewEmployee = [Employee Key]
AND ewStartDate <= GETDATE()
ORDER BY ewStartDate DESC