Thanks Mark Cowne.

That is the perfect solution.. and right in front of my eyes.... still, didn't figure it out.

DENSE_RANK() OVER(ORDER BY Id - register_sequence) AS seq_number

works beautifully!!

Hi Jeff and Johan,

I edited my original post, and included an id column, there's the only thing I can add to help sort the data.

I have other fields, but none...

• This reply was modified 2 years, 6 months ago by  vilaca.
• This reply was modified 2 years, 6 months ago by  vilaca.