Generate group sequence number

hi experts,

could please scenario.

input:

id | name  ---|-------  abc|india  abc|america  abc|china  bcd|brazil  bcd|japan

output:

grpkey|id | name  -----|---|---  1     |abc|india  1     |abc|america  1     |abc|china  2     |bcd|brazil  2     |bcd|japan

i want generate group keys above. please help

mus

declare @temp table (id varchar(100),name varchar(100)) insert @temp(id,name) select 'abc','india' union select 'abc','america' union select 'abc','china' union select 'bcd','brazil' union select 'bcd','japan' select dense_rank() on (order id) 'grpkey',id,name @temp 

---

ramesh rathod

SQL Server  >  SQL Server Integration Services