Skip to content

Instantly share code, notes, and snippets.

@ahmadrasyidsalim

ahmadrasyidsalim/query-bku-balik-ke-januari.sql

Created October 7, 2020 23:19
Show Gist options
  • Save ahmadrasyidsalim/b0d53c846f2d988923ef7131e1b028be to your computer and use it in GitHub Desktop.
Save ahmadrasyidsalim/b0d53c846f2d988923ef7131e1b028be to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query-bku-balik-ke-januari.sql
UPDATE
k
SET
k.id_rapbs_periode = rp.id_rapbs_periode
FROM
dbo.kas_umum k
JOIN dbo.rapbs_periode rp
ON rp.updater_id = k.id_rapbs_periode
JOIN dbo.rapbs r
ON r.id_rapbs = rp.id_rapbs
WHERE
r.id_anggaran = '{id}'
UPDATE
k
SET
k.id_anggaran = a.id_anggaran
FROM
dbo.kas_umum k
JOIN dbo.anggaran a
ON a.updater_id = k.id_anggaran
WHERE
k.id_anggaran = '{id}'
UPDATE
k
SET
k.id_anggaran = a.id_anggaran
FROM
dbo.aktivasi_bku k
JOIN dbo.anggaran a
ON a.updater_id = k.id_anggaran
WHERE
k.id_anggaran = '{id}'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment