CREATE procedure St_Proc_UpdateTimeSpent @timeEntryID int, @status int output as begin set nocount on; declare @Date dateTime; set @Date=GETDATE(); update Production set TimeSpent=(SELECT CONVERT(VARCHAR(20),DateAdd(SS,Datediff(ss,CalendarDate, @Date)%(60*60*24),0),114)), IsTaskCompleted=1 where productionTimeEntryID=@timeEntryID set @status=1; return @status; end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)