Oleg Netchaev (12/21/2010)
For example, the update in question can be easily restated like this:
Or, even more succinctly:
WITH Records (Old_Seq, New_Seq)
AS (
SELECT Seq,
ROW_NUMBER() OVER (PARTITION BY Value ORDER BY RecID)
FROM #Test
)
UPDATE Records
SET Old_Seq = New_Seq;
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi