Hi Skip,

Thanks for posting the code...made life much easier.

I have a stored procedure for you to try...note that I renamed #FPD_Schedule to FPD_Schedule so that the stored proc could update it...

CREATE PROC move_order @key INT,@line INT,@priority INT

AS

SET NOCOUNT ON;

-- collect the existing data for the key

DECLARE @old_priority INT,@old_line INT

SELECT @old_priority=priority,@old_line=line FROM FPD_Schedule WHERE =@key

-- move everything up on the line we are moving from

-- move everything down on the line we are moving to

-- move the specified order

UPDATE FPD_Schedule

SET priority= CASE

WHEN @key THEN @priority

ELSE

CASE

WHEN @line=@old_line THEN priority +

CASE

WHEN priority BETWEEN @priority AND @old_priority

OR priority BETWEEN @old_priority AND @priority THEN

CASE

WHEN @priority<@old_priority THEN 1

WHEN @priority>@old_priority THEN -1

ELSE 0

END

ELSE 0

END

WHEN line=@old_line AND priority>@old_priority THEN priority-1

WHEN line=@line AND priority>=@priority THEN priority+1

ELSE priority

END

END

, line = CASE

WHEN @key THEN @line

ELSE [line]

END

WHERE line=@line OR line=@old_line

It looks a bit horrific but that is just because I wanted to perform all updates in one statement - the alternative being to read /update

the table two or three times...which I wanted to avoid.