SQL Server Forums - How to update rows with row numbers

sql 2005 UPDATE t SET t.RowNo=t.Seq FROM (SELECT ROW_NUMBER() OVER (ORDER BY yourorderfield) AS Seq,* FROm Table)t WHERE t.Seq IN (2,5) sql 2000 UPDATE t SET t.RowNo=t.Seq FROM (SELECT (SELECT COUNT(*) FROM Table WHERE ...

www.sqlteam.com