ALTERTABLETmpADDIDXHintidentity(1,1) DECLARE@sNewNoteNoVARCHAR(50) EXECdbo.sppbGenerateNoteNoN'ML01',N'',1,@sNewNoteNoOUTPUT SELECT@sNewNoteNo DECLARE@iidINT SELECT@iid=NEXTVALUEFORsq_mmMaterialMst SELECT@iid DECLARE@iINT,@jINT,@cmone NVARCHAR(50) SELECT @i=min(xh) ,@j=MAX(xh)FR...