identity column in table

Question

hi,

 

I have bulk data and i have insert them into a new table with identity column like as below

identity row should be A1 for first 100 rows, A2 for second 100 rows, A3 for third 100 rows, etc...........

 

Please help me

 

Thanks,

Ani