usp_submittimesheet.sql

Beginning VB.NET DatabasesAll_Code.rar

CREATE PROCEDURE usp_SubmitTimeSheet
(
   @TimeSheetID   UNIQUEIDENTIFIER
)
AS

UPDATE TimeSheets
   SET Submitted = 1
   WHERE TimeSheetID = @TimeSheetID

IF @@ERROR <> 0 
   BEGIN
   RAISERROR('Submit timesheet failed.',18,1)
   RETURN
   END