[dbo].[MssWebUpdateTaskPriorities]

BUILD09 > MoversSuite2 > Stored Procedures > dbo.MssWebUpdateTaskPriorities

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

Permissions

Type	Action	Owning Principal
Grant	Execute	MssExec

SQL Script

create procedure [dbo].[MssWebUpdateTaskPriorities]
    @inTaskIds IntList readonly,
    @inTaskPriorityFid int
as
begin
set nocount on
    update ToDo
    set TaskPriorityFid = @inTaskPriorityFid
    from @inTaskIds ToDoIds
    inner join ToDo on ToDoIds.Item = ToDo.ToDoID;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateTaskPriorities] TO [MssExec]
GO

Uses

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