Hi,
I am hoping somebody can help me with this. I have data in a table that looks like the first table and I would like to write a query to update the sequence so it looks like the second table. Any ideas?
PersonID Color Sequence 1 Red 1 Blue 1 Green 2 Blue 3 Red 3 Blue
PersonID Color Sequence 1 Red 1 1 Blue 2 1 Green 3 2 Blue 1 3 Red 1 3 Blue 2