CREATE procedure [dbo].[MssWebUpdateOrderTask]
    @inOrderId int,
    @inToDoId int,
    @inChangedBySysuserId int,
    @inNewDueDate datetime,
    @inNewSysuserId int,
    @inNewNote varchar(max)
as
begin
    set nocount on
    -- Check if the specified task assosiated with respective order or not.
    if not exists (select 1 from ToDo where ToDo.OrderID = @inOrderId and ToDo.ToDoID = @inToDoID)
    return    
    -- Call the existing stored procedure ToDoUpdateTask
    exec [dbo].[ToDoUpdateTask]
        @inToDoID = @inToDoId,
        @inChangedBySysuserID = @inChangedBySysuserID,
        @inNewDueDate = @inNewDueDate,
        @inNewSysuserID = @inNewSysuserID,
        @inNewNote = @inNewNote
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateOrderTask] TO [MssExec]
GO