Gert Lombard's blog: Using SQL UPDATE with ROW_NUMBER()

update t set sortOrder = rowIndex from (select sortOrder, ROW_NUMBER() over(partition by Priority order by TodoId) as rowIndex from Todo where sortOrder is null ...

www.lombard.me