[dbo].[MssWebUpdateTaskPriority]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUpdateTaskPriority

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@inToDoIds	IntList	max
@inOrderId	int	4
@inTaskPriorityFid	int	4

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

CREATE procedure [dbo].[MssWebUpdateTaskPriority]
    @inToDoIds IntList readonly,
    @inOrderId int,
    @inTaskPriorityFid int
as
begin
set nocount on

    update ToDo
    set TaskPriorityFid = @inTaskPriorityFid
    from @inToDoIds ToDoIds
    inner join ToDo on ToDoIds.Item = ToDo.ToDoID
    where @inOrderId = ToDo.OrderID;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateTaskPriority] TO [MssExec]
GO

Uses

[dbo].[ToDo]
[dbo].[IntList]
dbo