ALTER TABLE #Tmp ADD IDXH int identity(1,1)

DECLARE @sNewNoteNo VARCHAR(50)

EXEC dbo.sppbGenerateNoteNo N'ML01', N'', 1, @sNewNoteNo OUTPUT

SELECT @sNewNoteNo

DECLARE @iid INT

SELECT @iid= NEXT VALUE FOR sq_mmMaterialMst

SELECT @iid 

DECLARE @i INT, @j INT，@cmone  NVARCHAR(50)

SELECT  @i=min(xh)  ,@j=MAX(xh)FROM #MAXCM;

WHILE @i<=@j

BEGIN

SELECT @cmone=Result FROM #MAXCM WHERE xh=@i;

SET @i=@i+1;

END;

DECLARE @i INT, @j INT;

SET @i=8461;

SET @J=10004;

WHILE @i<=@j

BEGIN

EXEC dbo.sppbGenerateIdenEx N'sdGmtOrderHdr',1,1000

SET @i=@i+1;

END;