Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OK, another one
Message
From
20/01/2009 15:02:07
Walter Meester
HoogkarspelNetherlands
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
01374859
Message ID:
01375610
Views:
22
Ok, count me in...


How about:
SELECT TimeSheets.EmployeeID, Month(WorkDate) as MonthPay , YEAR(WorkDate) AS YearPay,
   SUM(TimeSheets.HoursWorked * A.HourlyRate)  AS LaborDollars
        FROM TimeSheets
              	INNER JOIN WorkerRates A ON A.EmployeeID = TimeSheets.EmployeeID AND RateEffectiveDate <= WorkDate 
			AND RateAddedDate <= WorkDate
	WHERE NOT EXISTS(SELECT 1 FROM WorkerRates WHERE RateEffectiveDate <= WorkDate 
			AND RateAddedDate <= WorkDate AND (RateEffectiveDate > A.RateEffectivedate OR RateAddedDate > A.RateAddedDate))
    GROUP BY TimeSheets.EmployeeID, Month(WorkDate),YEAR(WorkDate)
Previous
Reply
Map
View

Click here to load this message in the networking platform