Untitled

mail@pastecode.io avatar
unknown
plain_text
2 months ago
915 B
2
Indexable
Never
INSERT INTO [bsi].[ddm].[masterDPK_BSI_20220131]
(periodedata,norekening,namarekening,nocif,tanggalbukarekening,kodeproduk,namaproduk,jenisproduk,golongannasabah,segmenbsi,kodebu,nisbahakhir,jenisvaluta,individu,jangkawaktu,nisbahkonter,spesialnisbah,jkwaktumulai,jkwaktujatuhtempo,kodeevent,kodeprogram,saldoratarata,saldolsmk,imbalan)
SELECT '01/31/2022' as [periodedata], v.norekening, v.namarekening, v.nocif, v.tanggalbukarekening, v.kodeproduk, v.namaproduk, v.jenisproduk, v.golongannasabah, v.segmenbsi, v.kodebu, v.nisbahakhir, v.jenisvaluta, v.individu, v.jangkawaktu, v.nisbahkonter, v.spesialnisbah, v.jkwaktumulai, v.jkwaktujatuhtempo, v.kodeevent, v.kodeprogram, v.saldoratarata, v.saldolsmk, v.imbalan
FROM [dbo].[d_20220131] v


Msg 241, Level 16, State 1, Line 16
Conversion failed when converting date and/or time from character string.

Completion time: 2024-02-19T16:48:07.3599815+07:00
Leave a Comment