Wage rate from Employee Base

9/8/2017 - 4:46 PM

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

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

Cacher is the code snippet organizer for pro developers