Declare Write_Cursor Cursor For

 Select a.AuditingID, a.BillType, a.AuditingDescription, a.AuditingStep, a.EtypeID, b.FullName, a.AuditingAlerm
 From AuditingFlowDetail a,Employee b
 Where  a.AuditingID = @nAuditingID
   And a.AuditingStep = @CurStep
   And a.EtypeID = b.TypeID
   AND outKty=@IfOut
 
 Open Write_Cursor
 
 Fetch Next From Write_Cursor Into @AuditingID, @BillType, @AudDesc, @AuditingStep, @ETypeID, @EName, @AuditingAlerm

 IF @IfOut='i' AND @OutLever<>1
 BEGIN
  Insert #AudDetail  ([AudID],[BillType],[Desc],[Step],[EtypeID],[Name],[AuditingAlerm])
      Values (@AuditingID, @BillType, @AudDesc, @AuditingStep-@OutLever+1,',',',', @AuditingAlerm)
  While @@Fetch_status = 0
 
  Begin
   Update #AudDetail
   Set [ETypeID] = [ETypeID] + @ETypeID + ',', [Name] = [Name] + @EName + ','
   Where Step = @CurStep-@OutLever+1
 
   Fetch Next From Write_Cursor Into @AuditingID, @BillType, @AudDesc, @AuditingStep, @ETypeID,  @EName, @AuditingAlerm
  END
 END

----------------------------------------------------

 

存储过程 游标

过程片段:
declare master_cursor CURSOR FOR
select hangbiaoshi  from tab_Test  order  by hangbiaoshi desc
open master_cursor

FETCH NEXT FROM master_cursor into @hangbiaoshi
while @@fetch_status = 0

BEGIN
 set @tmpcontent = ''
 declare senc_cursor CURSOR FOR
 select userName,content,date from tab_information where guanlianbiaoshi = @hangbiaoshi
 open senc_cursor
 FETCH NEXT FROM senc_cursor  into @user,@content,@date
 while @@fetch_status = 0
 begin

 set @tmpcontent =  @tmpcontent + @user + ':' + @content + '(' + convert(varchar(50),@date,120) + ')' + '<br>'
 FETCH NEXT FROM senc_cursor  into @user,@content,@date
 end
 
 insert into #resultTable values (@hangbiaoshi,@tmpcontent)

 CLOSE senc_cursor
 DEALLOCATE senc_cursor
 
FETCH NEXT FROM master_cursor into @hangbiaoshi
END

CLOSE master_cursor
DEALLOCATE master_cursor

select * from #resultTable

文章源自Web技术之家
 

上一篇：MSSQL行变列（列不固定）

下一篇：GHOST系统精简后没有IIS 解决数据库链接错误的方法