ini tabelnya
[JENISDOKUMEN] [nvarchar](50) NULL,
[NOBC] [nvarchar](50) NULL,
[TGLBC] [datetime] NULL,
[NOSJ] [nvarchar](50) NULL,
[TGLSJ] [datetime] NULL,
[BUYER] [nvarchar](50) NULL,
[KODEBARANG] [nvarchar](50) NULL,
[NAMABARANG] [nvarchar](250) NULL,
[SATUAN] [nvarchar](50) NULL,
[JUMLAH] [numeric](18, 0) NULL,
[NILAIBARANG] [numeric](18, 4) NULL,
[LAMBANG] [nvarchar](50) NULL
oke, saya coba dulu pak
terimakasih
Dari: si Nung <caksinung@gmail.com>
Kepada: belajar-access@yahoogroups.com
Dikirim: Rabu, 24 Oktober 2012 13:25
Judul: Bls: [belajar-access] ALTER proc
Apa saja utk tabel tujuannya
DATA_BC_30_BEA_CUKAI ?
Bagaimana bila di table tujuan tersebut ditambahi fieldnya juga, misal :
DELETE DATA_BC_30_BEA_CUKAI
INSERT INTO DATA_BC_30_BEA_CUKAI (JENISDOKUMEN,NOBC, dst)
SELECT 'BC 30' AS JENISDOKUMEN, NoBC30 AS NOBC, TanggalBC30 AS ... Dst
From: Vixion Dunia <vixiondunia@yahoo.co.id>
Sender: belajar-access@yahoogroups.com
Date: Wed, 24 Oct 2012 09:19:06 +0800 (SGT)
To: belajar-access@yahoogroups.com<belajar-access@yahoogroups.com>
ReplyTo: belajar-access@yahoogroups.com
Subject: 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 Website/Blog : Algoritma dan Pemrograman --- On Tue, 23/10/12, Vixion Dunia <vixiondunia@yahoo.co.id> wrote:
|
__._,_.___
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (12) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar