Mungkin di CONVERT (MONEY, DBO.DATA_BC_30_BEA_CUKAI.JUMLAH * DBO.DATA_BC_30_BEA_CUKAI.NILAIBARANG), ada data type text sehingga tidak bisa di convert ke number Pak
--- In belajar-access@yahoogroups.com, "Sofyan Efendi" <sofyanefendi@...> wrote:
>
> Pak, judulnya kepanjangan, saya pendekin ya.
>
> --- In belajar-access@yahoogroups.com, Vixion Dunia <vixiondunia@> wrote:
> >
> > selamat pagi semua
> >
> > saya mau menanyakan ketika saya membuat laporan menggunakan procedure terjadi error dibawah ini
> >
> > error converting data type varchar to numeric
> >
> >
> > ini procedurenya
> >
> > ALTER proc dbo.sp_bc30_beacukai as
> >
> > SET NOCOUNT ON
> > DELETE DATA_BC_30_BEA_CUKAI
> > INSERT INTO DATA_BC_30_BEA_CUKAI
> > SELECT 'BC 30' AS JENISDOKUMEN, NoBC30 AS NOBC, TanggalBC30 AS TGLBC, NoSuratJalan AS NOSJ, TGLSURATJALAN AS TGLSJ,
> > NamaBUYER AS BUYER, MODEL AS NAMABARANG, UNITBC30 AS SATUAN, JmlBC30 AS JUMLAH, HargaUSD AS NILAIBARANG,
> > '$' AS LAMBANG, NULL AS KODEBARANG
> > FROM dbo.[Data BC 30 All]
> > GROUP BY NoBC30, TanggalBC30, NoSuratJalan, NamaBuyer, Model, TglSuratJalan ,UnitBC30, JmlBC30, HargaUSD
> > ORDER BY NOBC
> >
> > SELECT DBO.DATA_BC_30_BEA_CUKAI.JENISDOKUMEN, DBO.DATA_BC_30_BEA_CUKAI.NOBC,
> > DBO.DATA_BC_30_BEA_CUKAI.TGLBC, DBO.DATA_BC_30_BEA_CUKAI.NOSJ,
> > DBO.DATA_BC_30_BEA_CUKAI.TGLSJ, DBO.DATA_BC_30_BEA_CUKAI.BUYER,
> > DBO.DATA_BC_30_BEA_CUKAI.NAMABARANG, DBO.DATA_BC_30_BEA_CUKAI.SATUAN,
> > DBO.DATA_BC_30_BEA_CUKAI.JUMLAH, DBO.DATA_BC_30_BEA_CUKAI.NILAIBARANG,
> > DBO.DATA_BC_30_BEA_CUKAI.LAMBANG, DBO.DATA_BC_30_BEA_CUKAI.KODEBARANG,
> > CONVERT (MONEY, DBO.DATA_BC_30_BEA_CUKAI.JUMLAH * DBO.DATA_BC_30_BEA_CUKAI.NILAIBARANG) AS TOTAL,
> > DBO.[Date Periode].AWALTGL, DBO.[Date Periode].AKHIRTGL
> > FROM DBO.DATA_BC_30_BEA_CUKAI CROSS JOIN
> > DBO.[Date Periode]
> > WHERE (DBO.DATA_BC_30_BEA_CUKAI.TGLBC BETWEEN dbo.[Date Periode].AWALTGL AND dbo.[Date Periode].AKHIRTGL)
> >
> >
> > dimana kah kira2 letak kesalahannya?
> >
> > terima kasih
> >
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
No comments:
Post a Comment