СК
create table #t
(
col1 int,
col2 int
)
insert #t(col1, col2)
values(1,101)
,(1,102)
,(2,203)
,(2,204)
,(3,305)
,(3,306)
SELECT col1, col2, col1*100+ROW_NUMBER() OVER(PARTITION BY col1 ORDER BY col2) newCol2
FROM #t
ORDER BY col1, col2;
(
col1 int,
col2 int
)
insert #t(col1, col2)
values(1,101)
,(1,102)
,(2,203)
,(2,204)
,(3,305)
,(3,306)
SELECT col1, col2, col1*100+ROW_NUMBER() OVER(PARTITION BY col1 ORDER BY col2) newCol2
FROM #t
ORDER BY col1, col2;
