Group ranking or row number

[Lash20]

Hi: I have data that looks like this: iYear RecordID Group 2010 1 A 2010 2 A 2010 3 A 2010 4 D 2010 5 D 2009 6 C 2009 7 C but I need to rank or apply row numbering on the Groups sorted by the RecordID to make the data look like this: iYear RecordID Group Group Ranking 2010 1 A 1 2010 2 A 1 2010 3 A 1 2010 4 D 2 2010 5 D 2 2009 6 C 3 2009 7 C 3 Any help would be greatly appreciated. Thx

[programmervb netc]

I would think you could use a case statement to accomplish that but that is probably not the best way.

Humble Programmer

[Mycroft Holmes]

This will make interesting reading[^] for you. Also look into PARTITION and RANK, that will allow you to rank the records over the group

Never underestimate the power of human stupidity RAH