/* */

Wednesday, November 28, 2012

Bls: [belajar-access] ALTER proc

 

bagaimana yah untuk attach table? atau ini saya coba ketik struktur tabelnya


Tabel bc30
[BC30ID] [int] IDENTITY(1,1) NOT NULL,
[NoBC30] [nvarchar](50) NULL,
[TanggalBC30] [datetime] NULL,
[BuyerID] [int] NULL,
[NoSuratJalan] [nvarchar](50) NULL,
[TglSuratJalan] [datetime] NULL,
Tabel bc30 detail
[BC30DETAILID] [int] IDENTITY(1,1) NOT NULL,
[BC30ID] [int] NULL,
[NO] [numeric](18, 0) NULL,
[GitarID] [int] NULL,
[JmlBC30] [numeric](18, 0) NULL,
[UnitBC30ID] [int] NULL,
[HargaUSD] [numeric](18, 3) NULL,
[HargaIDR] [numeric](18, 0) NULL,
tabel date periode
[ID] [int] IDENTITY(1,1) NOT NULL,
[AWALTGL] [datetime] NULL,
[AKHIRTGL] [datetime] NULL,


Dari: edi rosadi <edirosadie@yahoo.com.sg>
Kepada: belajar-access@yahoogroups.com
Dikirim: Selasa, 23 Oktober 2012 13:48
Judul: 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, 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)

 
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

 
  
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


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

No comments:

Post a Comment