yes i tried row_number also partioned by C_ID and C-rank, but it gives same numbers. Not working.

I tries something like this and it works:

create table #Temp_Table

(

C_ID int

, C_Rank char(1)

, Date...

Hi Vineet,

I did that way but it do not fulfill the requirement.

It do not work for ID 45. as it assign value 2 to second 'B' rank.

cycle should be assigned...

Thanks for replying,

I have one more column,

ID rank cycle(to be generated) Ship...