usp_selecttimesheetssubmitted.sql

来自「Beginning VB.NET DatabasesAll_Code.rar」· SQL 代码 · 共 16 行

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

SELECT 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 = 1
GROUP BY FirstName, LastName