<div>
<div class="content wysiwyg-content">
I've in SQL Server 7 a table grouppable where the key is X + Y.<br />
I would like to do a SELECT ordered by X and Y with a column that give me a progressive count inside the field X. To explain better, I have to receive<br />
X &nbsp; Y &nbsp; progr<br />
a &nbsp; a &nbsp; &nbsp; 1<br />
a &nbsp; b &nbsp; &nbsp; 2<br />
b &nbsp; a &nbsp; &nbsp; 1<br />
b &nbsp; b &nbsp; &nbsp; 2<br />
b &nbsp; c &nbsp; &nbsp; 3<br />
and so on.<br />
Someone know if I can obtain with only one SELECT?<br />
<br />
p.s. please, excuse my english<br />

</div>
</div>


I've in SQL Server 7 a table grouppable where the key is X + Y.
I would like to do a SELECT ordered by X and Y with a column that give me a progressive count inside the field X. To explain better, I have to receive
X   Y   progr
a   a     1
a   b     2
b   a     1
b   b     2
b   c     3
and so on.
Someone know if I can obtain with only one SELECT?

p.s. please, excuse my english


Progressive count in a select

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.