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