...,'A200', 28
Union all select 5 ,'A200', 28
Union all select 6 ,'A300', 12
Union all select 7 ,'A300', 12
Union all select 8 ,'A300', 12
Union all select 9 ,'A300', 12
)
select *, row-1+ROW_NUMBER() OVER(PARTITION BY [partner] ORDER BY [partner],[number] ASC) AS [Row2] from cte
soi là, soi...