SqlServer 取得行号且保持数据的原序列【分组定义序号】

declare @Base_NO NVARCHAR(30)
set @Base_NO='ISO2015002'


SELECT SORT=identity(int,1,1),* into #temp
from GetJFBZList(@Base_NO);


select t1.NO,t1.MCODE,t2.* from
(select ROW_NUMBER() over (order by t.MCODE_ID) as NO, t.MCODE from (
select MCODE, MIN(SORT) AS MCODE_ID from #temp group by MCODE) t )t1
inner join #temp t2 ON t1.MCODE = t2.MCODE
order by t2.SORT;


drop table #temp;