SQL Serve: Using nested cursors
declare @o int
declare @c int
declare @delim varchar(200)
set @delim = '++++++++++++++++++++++++++++++++++++++++'
declare gd1 cursor local for
select id from TABLE_1 where
open gd1
fetch next from gd1 into @o
while @@FETCH_STATUS = 0
begin
print @delim
print @o
declare gd2 cursor local for
select id from TABLE_2 where table1_id = @o
open gd2
fetch next from gd2 into @c
while (@@FETCH_STATUS = 0)
begin
print '--->' + convert(varchar , @c)
fetch next from gd2 into @c
end
close gd2
deallocate gd2
fetch next from gd1 into @o
end
close gd1
deallocate gd1
Comments
10.10.2011
brilliant!
Leave a trace
Post being viewed right now
