Incrementing Identifier in Query

[RossC0]

Hi,

I have a table that has UK regions and I want run a query that groups by region and includes an outputted ID field i.e.

Region :: ID
London 1
Midlands 2
.. ..

Is there away to do that in SQL ?

 

[CT Witter]

Try MS KB article: 199679 - How to Simulate a Dynamic Counter in a Table or a Query to Count Records

http://support.microsoft.com/default.aspx?scid=kb;en-us;199679&Product=acc

HTH,
CT