游标嵌套

游标可以嵌套。
游标嵌套
DECLARE CUR_1 CURSOR--第一层游标声明
FOR SELECT C_1,C_2 FROM TABLENAME
OPEN CUR_1
FETCH NEXT FROM CUR_1 INTO @C_1,@C_2
WHILE @@FETCH_STATUES<>0
BEGIN
    DECLARECUR_2 CURSOR--第二层游标声明
    FOR SELECTA_1,A_2 FROM TABLENAME
    OPENCUR_2
    FETCH NEXTFROM CUR_2 INTO @C_1,@C_2
    WHILE@@FETCH_STATUES<>0
    BEGIN
       .....
       .....
       FETCH NEXTFROM CUR_2 INTO @A_1,@A_2--二层循环
    END
    CLOSECUR_2
    DEALLOCATECUR_2
FETCH NEXT FROM CUR_1 INTO@C_1,@C_2--一层循环   
END
CLOSE CUR_1
DEALLOCATE CUR_1


http://blog.sina.com.cn/s/blog_604fb7ae01012jhn.html