CREATEprocedure[dbo].[MssWebUpdateTaskComplete] @inOrderIdint, @inToDoIdint, @inCompletebit, @inSysUserIdint, @inDueDatedate as begin setnocounton ifexists(select1fromToDowhereToDo.OrderID=@inOrderIdandToDo.ToDoID=@inToDoId) begin execspUpdateTaskComplete@inToDoId,@inComplete,@inSysUserId,@inDueDate end end GO GRANTEXECUTEON[dbo].[MssWebUpdateTaskComplete]TO[MssExec] GO