create table t

(

id int identity (1,1),

i int,

a varchar(10)

)

Select id,i, a, Row_Order=(select count(T1.i) + 1

from t T1

where T1.id < T.id and t1.a = t.a

)

from t T