Untitled

                Never    
SQL
       
update data
	set id_index = s.newid from 
		(select indexnumber, (row_number() over (partition by id_permutation order by indexnumber)) - 1 As newid from data) As s
	where s.indexnumber = data.indexnumber;

Raw Text