Excellent, thank you Des and Chris.  I will be studying this today!  I always love posting here, I learn something new every time.

Having said that, I would prefer to not rely on an "edited" column being updated by the client as client times could be inaccurate/time zone dependent.

I would either replace that...

mister.magoo (8/21/2016)

---

How is this not just a simple update/cte?

WITH CTE AS

(

SELECT

seq

, ROW_NUMBER() OVER

(

...

CELKO (8/17/2016)

---

I apologize for this half answer, but in some of my books I have an update statement that uses a case expression (not a case statement, please?) To move...

drew.allen (8/17/2016)

---

I realized this morning that my code needed a slight update. My updates sample data had the same ordering for the from_seq and the to_seq, but that is...

drew.allen (8/16/2016)

---

Here is a version that allows you to update multiple records at the same time.

DECLARE @a TABLE (

seqINT,

orig_seq INT

)

INSERT @a( seq, orig_seq)

VALUES(1, 1), (2, 2),...

Luis Cazares (8/16/2016)

---

An additional clause should do the trick.

WITH CTE AS(

SELECT *, ROW_NUMBER() OVER( ORDER BY CASE WHEN seq = @OldSeq THEN @NewSeq

...

Luis Cazares (8/16/2016)

---

What about this?

create table #temp(seq int,step varchar(50))

insert into #temp (seq,step) values (1,'do this first')

insert into #temp (seq,step) values (2,'then do this')

insert into #temp (seq,step) values (3,'finally do this')

insert...

Ah good point :Whistling: That was most likely my stumbling block prior to...

I started this thread years ago - brings...

drew.allen (8/12/2015)

---

This works by creating a "loop" in a random order and assigning the previous person in the loop as the reviewer.

DECLARE @temp TABLE (id int,logonid varchar(15),reviewer varchar(15))

insert into...

Yes. By balanced I'm guessing you mean each Logonid must be assigned as a Reviewer and can only be assigned once.

Thank...

For example, personA would be assigned...

Those listed in the Logonid column will be the reviewers. So...

Those listed in the Logonid column are the reviewes. So personA might be assigned to personC etc. PersonA obviously can't be assigned as a reviewer to PersonA, that...