DO $$
Declare idmaset int;
declare idkrtaset int;
Declare bulanke int;
DECLARE idasetinv int;
Declare jwl date;
cur1 CURSOR for select ID from m_aset_inventaris
where id_bpr = 2 and id_bpr_cabang = 1;
cur2 cursor for select id, depresiasi_bulan_ke, id_aset_inventaris, jwl_depresiasi
from m_kartu_aset_inventaris where id_aset_inventaris=idmaset
order by depresiasi_bulan_ke;
begin
OPEN Cur1 ;
Loop
FETCH next from Cur1 INTO idmaset;
EXIT WHEN NOT FOUND;
open cur2;
loop
FETCH next from Cur2 INTO idkrtaset, bulanke, idasetinv, jwl;
EXIT WHEN NOT FOUND;
update m_kartu_aset_inventaris
set jwl_depresiasi=((select jwl_depresiasi from m_kartu_aset_inventaris where depresiasi_bulan_ke < bulanke and id_aset_inventaris=idasetinv order by depresiasi_bulan_ke desc limit 1) +(interval '1 MONTH'))
where id_aset_inventaris=idasetinv and depresiasi_bulan_ke=bulanke and depresiasi_bulan_ke >1;
END LOOP;
CLOSE cur2;
end loop ;
CLOSE Cur1;
END $$;
Langganan:
Posting Komentar (Atom)
Dynamic Query - SQL Server
Berikut adalah contoh dari bentuk dari Dynamic Query di SQL Server yang dibungkus ke dalam Store Procedure: USE [Data00] GO SET ANSI_NULLS ...
Popular Posts
-
CONTOH PENGGUNAAN LOOPING CASE UNTUK UPDATE TANGGAL BAYAR YANG NULL PADAHAL ANGSURAN DI ATASNYA ADA TGL PEMBAYARANNYA declare @norek varc...
-
UBAH FORMAT TANGGAL CONTOH DI DATABASE FORMATNYA YYYY/MM/DD, KITA UBAH JADI DD/MM/YYYY select a.nomor_register_aplikasi no_rekening, a.na...
-
SELECT THN, BLN_THN, KODE, COUNTER_MAX, COUNTER, PANJANG, CASE WHEN PANJANG=4 THEN TO_CHAR(COUNTER) WHEN PANJANG=3 T...
Tidak ada komentar:
Posting Komentar