存储过程while循环

declare calculate_item cursor
for select code code2,name name2 from biz_calculate_item where kjqj = left(@kjqj,4) and org_code = @orgCode
open calculate_item 
declare @code2 varchar(50),@name2 varchar(50)
fetch next from calculate_item into @code2,@name2
while @@FETCH_STATUS = 0
begin
    // 第二层循环前面的代码和上面一致
    ......
    while
        begin
        end
    close ....
    deallocate ....
    fetch next from calculate_item into @code2,@name2    
end
close calculate_item
deallocate calculate_item

动态sql

declare @str varchar(800)
set @str = 'select code code3,name name3 from biz_calculate_dept where kjqj = '''+left(@kjqj,4)+''' and org_code = '''+@orgCode+'''  '
if(ISNULL(@costLevel,'')<>'') set @str +=  'and calculate_level = ''' + @costLevel + ''''
if(ISNULL(@deptCode,'')<>'') set @str +=  'and code = ''' + @deptCode + ''''
exec('declare calculate_dept cursor for ' + @str)
open calculate_dept 
declare @code3 varchar(50),@name3 varchar(50)
fetch next from calculate_dept into @code3,@name3
while @@FETCH_STATUS = 0
begin

end