select *,
         row_num=convert(int, null)
into #t
from t

update #t set row_num = (select count(*) from t where t.field_of_sorting < #t.field_of_sorting)

select * from #t