-- define cursor1
SET @curSample = CURSOR LOCAL FOR ....
-- open cousor
OPEN @curSample
FETCH NEXT FROM @curSample...
WHILE @@FETCH_STATUS = 0
BEGIN
-- define cursor2
SET @curSample2 = CURSOR LOCAL FOR ....
-- open cursor
OPEN @curSample2
FETCH NEXT FROM @curSample2...
WHILE @@FETCH_STATUS = 0
BEGIN
処理A
FETCH NEXT FROM @curSample2...
END
FETCH NEXT FROM @curSample...
END