Looping Angka Urut - SQL Server

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

create table #kartudeposito (NO_REK varchar(15), SIKLUS int, ANGS_KE int, BUNGA numeric, PAJAK numeric, TGL_JWL date, POKOK numeric, RECID int);


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

-- untuk looping noreknya
declare SalesCursor cursor for
    SELECT YY.no_rekening, yy.tgl_jttempo
        FROM DEPOSITO_BUNGA YY
        JOIN #TEMP_DEP XX ON YY.no_rekening=XX.NO_REK and xx.freq_pemb=xx.JANGKA

SET @Counter = 1

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

        -- baru untuk recid nya (angka urut)
        insert into #kartudeposito
        SELECT YY.no_rekening, 1 siklus,
        null angsuran_ke,
        yy.nilai, (yy.nilai*20/100) pajak, yy.tgl_jttempo, xx.SALDO, @Counter
        FROM DEPOSITO_BUNGA YY
        JOIN #TEMP_DEP XX ON YY.no_rekening=XX.NO_REK and xx.freq_pemb=xx.JANGKA
        and yy.no_rekening=@norek and yy.tgl_jttempo=@tgl

        SET @Counter = @Counter + 1
       
   
FETCH NEXT FROM SalesCursor INTO @norek,@tgl
END  
CLOSE SalesCursor  
DEALLOCATE SalesCursor;