Adding Sequential Number to a repeating record

[mrodonis]

thread183-859372

The original thread does what I need when the repeated record is an Integer, but I need this when the record is a varchar. For example, I have the following client_tag field, where I need to add a sequential number for each record that is the identical, restarting the sequence for each new Client_Tag.

Client_Tag Seq (Need to add this column)

AA00001224 1
AA00001224 2
AA00001224 3
BB00001234 1
CC00001233 1
CC00001233 2

I appreciate any assistance with this.
Thanks!

 

[simian336]

look at the rank function in bol.

Simi

 

[imex]

Try something like this:

select
    Client_Tag,
    ROW_NUMBER() OVER(PARTITION BY Client_Tag ORDER BY Client_Tag) AS Seq
from MyTable

Hope this helps.


Imoveis em Guarulhos

 

[mrodonis]

Imex,
Thanks so much, that worked perfectly!