MARIProject Database Structure

/*
 * MARIProject Version 4.9
 * ProjectManagement.SQLScript4.9.HoursPerEmployeeAndDate.sql
 */
 
SELECT 
	SUM(MARIProjectTimeKeepingLines.Quantity) AS HoursUsed, 
	MARIProjectTimeKeepingHeader.EmployeeNumber,
	MARIProjectTimeKeepingLines.ServiceDate
FROM MARIProjectTimeKeepingHeader
INNER JOIN MARIProjectTimeKeepingLines 
	ON MARIProjectTimeKeepingHeader.TimeKeepingHeaderID=MARIProjectTimeKeepingLines.TimeKeepingHeaderID
GROUP BY 
	MARIProjectTimeKeepingHeader.EmployeeNumber, 
	MARIProjectTimeKeepingHeader.Period,
	MARIProjectTimeKeepingLines.ServiceDate