Update column counter per group

gistfile1.sql

;with Counters as (
	select Id, 
		row_number() over (partition by GroupingColumn order by GroupingColumn asc) as [Counter]
	from RequisitionLine
)
update T
	set T.[Counter] = C.[Counter]
	from MyTable T inner join Counters C on T.Id = C.Id