Stored Procedure cursor

Process segment:
Declare master_cursor cursor
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
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