I want to create a unique identifier based on a possible grouping and can't figure out how to accomplish this.
For example, If I had 3 users named Tom, 2 named Bill and 2 name Suzie, I want to be able to generate via a select query group id's for the users like the list below.
Name | ID | __________________ Tom 1, Tom 1, Tom 1, Bill 2, Bill 2, Suzie 3, Suzie 3
I currently have a function in MS Access that does this for me, but I can't figure out how to work this out in SQL. Your help is appreciated.