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
