>>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...

Or it should simply be

TimeSheets.WorkDate >=WorkerRates.RateEffectiveDate and TimeSheets.WorkDate >=WorkerRates.RateAddedDate

Let's try with this adjustment.