Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
| Name | Data Type | Length | Description |
|---|---|---|---|
| @username | varchar | 20 | |
| @id | bigint | 8 | |
| @kodebarang | varchar | 20 | |
| @nomor_hs | varchar | 200 | |
| @partumber | varchar | 200 | |
| @jenis_tarif_bm | varchar | 200 | |
| @jenis_tarif_cukai | varchar | 200 | |
| @tarif_ppnbm | decimal | 9 | |
| @tarif_bm | decimal | 9 | |
| @tarif_cukai | decimal | 9 | |
| @tarif_pph | decimal | 9 | |
| @tarif_ppn | decimal | 9 | |
| @cmd | varchar | 20 | |
| @fromdate | date | 3 | |
| @todate | date | 3 | |
| @grdate | date | 3 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.TEST_GRN_INSERT
@username AS VARCHAR(20),
@id AS BIGINT , @kodebarang AS VARCHAR(20),@nomor_hs AS VARCHAR(200),
@partumber AS VARCHAR(200),
@jenis_tarif_bm AS VARCHAR(200),
@jenis_tarif_cukai AS VARCHAR(200),
@tarif_ppnbm AS DECIMAL(18,4),
@tarif_bm AS DECIMAL(18,4),
@tarif_cukai AS DECIMAL(18,4),
@tarif_pph AS DECIMAL(18,4),
@tarif_ppn AS DECIMAL(18,4),
@cmd AS VARCHAR(20),
@fromdate AS date,
@todate AS date,
@grdate AS date
AS
BEGIN
BEGIN
EXEC(
' IF NOT EXISTS(SELECT * FROM test_compare WHERE GRDATE between '''+@fromdate+''' and '''+@todate+''' AND PARTNUMBER = '''+@partumber+
''' ) BEGIN INSERT INTO test_compare(from_date,to_date, status, PARTNUMBER,GRDATE) VALUES('''+@fromdate+''','''+@todate+''', 1,'''+@partumber+''','''+@grdate+
''') END ')
SELECT '00' AS 'STATUS','Data Master on BC berhasil diupdate' AS 'DESCRIPTION'
RETURN
END
SELECT '06' AS 'STATUS','Data Master on BC gagal diupdate' AS 'DESCRIPTION'
END
GO
GO
CREATE PROCEDURE dbo.TEST_GRN_INSERT
@username AS VARCHAR(20),
@id AS BIGINT , @kodebarang AS VARCHAR(20),@nomor_hs AS VARCHAR(200),
@partumber AS VARCHAR(200),
@jenis_tarif_bm AS VARCHAR(200),
@jenis_tarif_cukai AS VARCHAR(200),
@tarif_ppnbm AS DECIMAL(18,4),
@tarif_bm AS DECIMAL(18,4),
@tarif_cukai AS DECIMAL(18,4),
@tarif_pph AS DECIMAL(18,4),
@tarif_ppn AS DECIMAL(18,4),
@cmd AS VARCHAR(20),
@fromdate AS date,
@todate AS date,
@grdate AS date
AS
BEGIN
BEGIN
EXEC(
' IF NOT EXISTS(SELECT * FROM test_compare WHERE GRDATE between '''+@fromdate+''' and '''+@todate+''' AND PARTNUMBER = '''+@partumber+
''' ) BEGIN INSERT INTO test_compare(from_date,to_date, status, PARTNUMBER,GRDATE) VALUES('''+@fromdate+''','''+@todate+''', 1,'''+@partumber+''','''+@grdate+
''') END ')
SELECT '00' AS 'STATUS','Data Master on BC berhasil diupdate' AS 'DESCRIPTION'
RETURN
END
SELECT '06' AS 'STATUS','Data Master on BC gagal diupdate' AS 'DESCRIPTION'
END
GO
Depends On
No items found
Used By
No items found