>Your numbers are wrong for the month of March (and I believe November)
>
>Remember that we want to know, after the fact, what was paid out at the time.
>
>

>-- Employee gets a three month review on 3-24, gets a raise to 25.00, effective 4-1
>INSERT INTO WorkerRates VALUES (1,'4-1-2008','3-24-2008', 25.00)
>

Is this logic correct?

TimeSheets.WorkDate >= (CASE WHEN WorkerRates.RateEffectiveDate > WorkerRates.RateAddedDate THEN WorkerRates.RateAddedDate ELSE WorkerRates.RateEffectiveDate END)

I have some hard time figuring date logic...