Home Forums SQL Server 2008 T-SQL (SS2K8) Repopulating a sequenced column that has gone out of sequence. RE: Repopulating a sequenced column that has gone out of sequence.
Lynn Pettis
SSC Guru
Points: 442467
More actions
July 5, 2014 at 10:56 am
#1727168
This is all you needed:
With cte As
(
select IntSequence, ROW_NUMBER() OVER (order by externalsequence asc) as rownumber from labels
)
update cte
set IntSequence = rownumber;