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;
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;