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 (3) |
No comments:
Post a Comment