Stored Procedures [dbo].[MssWebUpdateTaskNotApplicable]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@inOrderIdint4
@inToDoIdint4
@inSysUserIdint4
@inDueDatedate3
@inNotApplicableFlagbit1
Permissions
TypeActionOwning Principal
GrantExecuteMssExec
SQL Script
CREATE procedure [dbo].[MssWebUpdateTaskNotApplicable]
    @inOrderId int,
    @inToDoId int,
    @inSysUserId int,
    @inDueDate date,
    @inNotApplicableFlag bit
as
begin
    set nocount on
    if exists ( select 1 from ToDo where ToDo.OrderID = @inOrderId and ToDo.ToDoID = @inToDoId)
    begin
        exec ToDoUpdateNotApplicable @inToDoId,@inSysUserId,@inDueDate,@inNotApplicableFlag
    end
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateTaskNotApplicable] TO [MssExec]
GO
Uses