Hi everybody,

Can you please suggest an efficient algorithm of re-numbering? I have a table with the sequence number field (per each unique Fk). The sequence_number is supposed to be correct 1,2,3, etc., but we have data problem and some numbers are repeated.

How can I re-number my records?

Thanks in advance.