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