--创建游标
DECLARE AGNTNM CURSOR Local for
select agntnum from [dbo].[DM_LA_HSAGPF] group by agntnum;
DECLARE DM_HSAGPF CURSOR Local for
open AGNTNM; --开游标
FETCH NEXT FROM AGNTNM INTO @agtnum; --获取游标的下一行
WHILE ( @@fetch_status = 0 )
begin
set @MAX_SEQ=@MAX_SEQ + 1;
insert into @POS_SEQ (POS_SEQ,agntnum,RECORDTYPE) select case when seqnum = null
then @MAX_SEQ else seqnum end,@agtnum,'AGT'
from DM_LA_MASTER where agntnum=@agtnum;
FETCH NEXT FROM AGNTNM INTO @agtnum --获取游标的下一行
end
CLOSE AGNTNM --关闭游标