-- FORMAT SAS
INSERT INTO [DIR_WILAYAH1].[penyaluranapp].[upload_sas_files_content]
(
[created_at]
,[updated_at]
,[created_by]
,[NILAI]
,[NAMA_PENERIMA]
,[KODE_BANK]
,[KODE_SWIFT]
,[KODE_IBAN]
,[NOREKENING]
,[NOMOR_KARTU]
,[NIK_KTP]
,[KODE_WILAYAH]
,[TAHAP]
)
--query Format SAS
SELECT
GETDATE() AS created_at,
GETDATE() AS updated_at,
1 AS created_by,
NOMINAL_BANTUAN AS NILAI,
NAMA_PENERIMA AS NAMA_PENERIMA,
'520009000990' as KODE_BANK,
'' as KODE_SWIFT,
'' as KODE_IBAN,
NOREKENING,
NOMOR_KARTU,
NIK AS NIK_KTP,
KODE_WILAYAH,
'5' AS TAHAP
FROM [DTKS_PFM].[feedback_pfm].[SEMBAKO_WIL_1]
WHERE TAHAP = '5'
AND FLAG_DATA = '1'
AND BANK = 'BNI'