MS ACCESS MAILING LIST: Re: [belajar-access] 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

cek struktur tabel yang memiliki tipe nvarchar, kemudian periksa di SP-nya apakah mengalami proses perhitungan/aritmatika.

bisa attach struktur tabelnya?

Salam,

Edi Rosadi

Application Developer & Consultant

Website/Blog :
Algoritma dan Pemrograman

Peta Industri dan Wisata Cilegon
Blog Bahasa Cilegon

Facebook-Perancangan Sistem

komersilkan blog atau website anda dengan bergabung di sini atau di sini

--- On Tue, 23/10/12, Vixion Dunia <vixiondunia@yahoo.co.id> wrote:

From: Vixion Dunia <vixiondunia@yahoo.co.id>
Subject: [belajar-access] 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)
To: "access" <belajar-access@yahoogroups.com>
Date: Tuesday, 23 October, 2012, 11:39 AM

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