usp_selecttimesheetsdue.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE PROCEDURE usp_SelectTimeSheetsDue
(
   @ManagerID         UNIQUEIDENTIFIER,
   @WeekEndingDate   DATETIME
)
AS

SELECT Email, FirstName + ' ' + LastName AS UserName, SUM(Hours) AS TotalHours
FROM TimeSheets
LEFT OUTER JOIN TimeSheetItems ON TimeSheets.TimeSheetID = TimeSheetItems.TimeSheetID
LEFT OUTER JOIN Users ON TimeSheets.UserID = Users.UserID
WHERE Users.ManagerID = @ManagerID
AND WeekEndingDate = @WeekEndingDate
AND Submitted = 0
GROUP BY FirstName, LastName, Email