Hello @ll,

in a table there a many records with prioritys 1, 4, ..

Now the user can set one record to 5 and after this, I would set all other records before in steps of 10 and after this again:

For Example:

Before

Record 1 prio 3

Record 2 prio 10

Record 3 prio 18

Record 4 prio 20

Record 5 prio 30

The user set the record 4 to prio 15, I would like to do this:

Record 1 from 3 to 10

Record 2 from 10 to 20

Record 3 from 20 (should 15, Destination between record 2 and record 3)) to 30

Record 4 to 40

Record 5 to 50

How can I realize this without a loop? Update table set prio = …? Or with cte?

Thank you.

Best regards.

Olaf