Looping Di Dalam Looping - SQL Server

if OBJECT_ID('tempdb.dbo.#tempkrtdep', 'U') is not null
drop table #tempkrtdep;

create table #tempkrtdep(no_rek varchar(15), angsuran_ke int, tgltempo date, nominalpokok int, bunga varchar(5));

declare @norek varchar(15)
declare @jangka int
declare @jangka2 int
declare @Counter int

-- untuk looping noreknya
declare SalesCursor cursor for
    select NO_REK,JANGKA from TEMP_DEP ;


open SalesCursor
fetch next from SalesCursor into @norek,@jangka
WHILE @@FETCH_STATUS = 0
    begin

    -- untuk looing jangkanya
    declare SalesCursor2 cursor for select @jangka
    SET @Counter = 1

    open SalesCursor2
    fetch next from SalesCursor2 into @jangka2
    WHILE @Counter <= @jangka2
    begin

        insert into #tempkrtdep
        select
        NO_REK,@Counter, TGL_DUE, NOMINAL, BUNGA
        from TEMP_DEP where NO_REK=@norek

        SET @Counter = @Counter + 1
        CONTINUE;
   
    fetch next from SalesCursor into @jangka2
    end
    close SalesCursor2
    deallocate SalesCursor2
   

FETCH NEXT FROM SalesCursor INTO @norek,@jangka
END  
CLOSE SalesCursor  
DEALLOCATE SalesCursor

SELECT * FROM #tempkrtdep order by no_rek, angsuran_ke