[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,

 

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 (1)

Recent Activity:

• New Members 9
• New Files 1

Visit Your Group

SPAM IS PROHIBITED

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___