Comments by FARMAN786 (Top 21 by date)

Hi There I changed my Stored Procedure and I think it inserted a couple of records into the db and then again it stopped, it gives me a message that it did but no record, I am pasting my Stored Proc here sorry

USE [SDPRD]
GO
/****** Object: StoredProcedure [dbo].[taUpdateCreateItemRcdPost] Script Date: 05/08/2013 10:58:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[taUpdateCreateItemRcdPost]

@I_vITEMNMBR char(30),
@I_vITEMDESC char(100),
@I_vITMSHNAM char(15),
@I_vITMGEDSC char(10),
@I_vITMCLSCD char(10),
@I_vITEMTYPE smallint,
@I_vVCTNMTHD smallint,
@I_vTAXOPTNS smallint,
@I_vITMTSHID char(15),
@I_vUOMSCHDL char(10),
@I_vITEMSHWT numeric(8,2),
@I_vTCC char(30),
@I_vCNTRYORGN char(6),
@I_vDECPLQTY smallint,
@I_vDECPLCUR smallint,
@I_vPurchase_Tax_Options smallint,
@I_vPurchase_Item_Tax_Schedu char(15),
@I_vSTNDCOST numeric(19,5),
@I_vCURRCOST numeric(19,5),
@I_vALTITEM1 char(30),
@I_vALTITEM2 char(30),
@I_vITMTRKOP smallint,
@I_vINCLUDEINDP tinyint,
@I_vMINSHELF1 smallint,
@I_vMINSHELF2 smallint,
@I_vALWBKORD tinyint,
@I_vWRNTYDYS smallint,
@I_vABCCODE smallint,
@I_vUSCATVLS_1 char(10),
@I_vUSCATVLS_2 char(10),
@I_vUSCATVLS_3 char(10),
@I_vUSCATVLS_4 char(10),
@I_vUSCATVLS_5 char(10),
@I_vUSCATVLS_6 char(10),
@I_vKPCALHST tinyint,
@I_vKPERHIST tinyint,
@I_vKPTRXHST tinyint,
@I_vKPDSTHST tinyint,
@I_vIVIVACTNUMST varchar(75),
@I_vIVIVOFACTNUMST varchar(75),
@I_vIVCOGSACTNUMST varchar(75),
@I_vIVSLSACTNUMST varchar(75),
@I_vIVSLDSACTNUMST varchar(75),
@I_vIVSLRNACTNUMST varchar(75),
@I_vIVINUSACTNUMST varchar(75),
@I_vIVINSVACTNUMST varchar(75),
@I_vIVDMGACTNUMST varchar(75),
@I_vIVVARACTNUMST varchar(75),
@I_vPURPVACTNUMST varchar(75),
@I_vIVRETACTNUMST varchar(75),
@I_vKTACCTSR smallint,
@I_vPRCHSUOM char(8),
@I_vRevalue_Inventory tinyint,
@I_vTolerance_Percentage numeric(19,2),
@I_vLOCNCODE char(10),
@I_vPRICMTHD smallint,
@I_vPriceGroup char(10),
@I_vUseItemClass tinyint,
@O_iErrorState int output,
@oErrString varchar(255) output
as set nocount on select @O_iErrorState = 0 return (@O_iErrorState)


/*********************** Initialize locals *****************************************************/
select
@O_iErrorState = 0,
@oErrString = ''

INSERT INTO [IV00101]
(
[ITEMNMBR],
[ITEMDESC],
[ITMSHNAM],
[ITMGEDSC],
[ITMCLSCD],
[ITEMTYPE],
[VCTNMTHD],
[TAXOPTNS],
[ITMTSHID],
[UOMSCHDL],
[ITEMSHWT],
[TCC],
[CNTRYORGN],
[DECPLQTY],
[DECPLCUR],
[Purchase_Tax_Options],
[Purchase_Item_Tax_Schedu],
[STNDCOST],
[CURRCOST],
[ALTITEM1],
[ALTITEM2],
[ITMTRKOP],
[INCLUDEINDP],
[MINSHELF1],
[MINSHELF2],
[ALWBKORD],
[WRNTYDYS],
[ABCCODE],
[USCATVLS_1],
[USCATVLS_2],
[USCATVLS_3],
[USCATVLS_4],
[USCATVLS_5],
[USCATVLS_6],
[KPCALHST],
[KPDSTHST],
[KPERHIST],
[KPTRXHST],
[IVIVINDX],
[IVIVOFIX],
[IVCOGSIX],
[IVSLSIDX],
[IVSLDSIX],
[IVSLRNIX],
[IVINUSIX],
[IVINSVIX],
[IVDMGIDX],
[IVVARIDX],
[PURPVIDX],
[IVRETIDX],
[KTACCTSR],
[PRCHSUOM],
[Revalue_Inventory],
[Tolerance_Percentage],
[LOCNCODE],
[PRICMTHD],
[PriceGroup]
)
VALUES
(
@I_vITEMNMBR,
@I_vITEMDESC,
@I_vITMSHNAM,
@I_vITMGEDSC,
@I_vITMCLSCD,
@I_vITEMTYPE,
@I_vVCTNMTHD,
@I_vTAXOPTNS,
@I_vITMTSHID,
@I_vUOMSCHDL,
@I_vITEMSHWT,
@I_vTCC,
@I_vCNTRYORGN,
@I_vDECPLQTY,
@I_vDECPLCUR,
@I_vPurchase_Tax_Options,
@I_vPurchase_Item_Tax_Schedu,
@I_vSTNDCOST,
@I_vCURRCOST,
@I_vALTITEM1,
@I_vALTITEM2,
@I_vITMTRKOP,
@I_vINCLUDEINDP,
@I_vMINSHELF1,
@I_vMINSHELF2,
@I_vALWBKORD,
@I_vWRNTYDYS,
@I_vABCCODE,
@I_vUSCATVLS_1,
@I_vUSCATVLS_2,
@I_vUSCATVLS_3,
@I_vUSCATVLS_4,

Will I be able to do this in the Stored Proc and Insert, Sorry to paste it here

CREATE PROCEDURE [dbo].[SD_InsertInventoryItem]
-- Add the parameters for the stored procedure here
(
@ITEMNMBR char(30),
@ITEMDESC char(100),
@ITMSHNAM char(15),
@ITMGEDSC char(10),
@ITMCLSCD char(10),
@ITEMTYPE smallint,
@VCTNMTHD smallint,
@TAXOPTNS smallint,
@ITMTSHID char(15),
@UOMSCHDL char(10),
@ITEMSHWT numeric(8,2),
@TCC char(30)
@iErrorState int output,
@ErrString varchar(255) output

)

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert the Transfer Line Item
EXECUTE dbo.taUpdateCreateItemRcd
@I_vITEMNMBR = @ITEMNMBR,
@I_vITEMDESC = @ITEMDESC,
@I_vITMSHNAM = @ITMSHNAM,
@I_vITMGEDSC = @ITMGEDSC,
@I_vITMCLSCD = @ITMCLSCD,
@I_vITEMTYPE = @ITEMTYPE,
@I_vVCTNMTHD = @VCTNMTHD,
@I_vTAXOPTNS = @TAXOPTNS,
@I_vITMTSHID = @ITMTSHID,
@I_vUOMSCHDL = @UOMSCHDL,
@I_vITEMSHWT = @ITEMSHWT,
@I_vTCC = @TCC,
@O_iErrorState = @iErrorState,
@oErrString = @ErrString
)

I mean I cannot change the stored proc but if I have to use the Insert statement how and where would be the good idea to do this.

Thanks a lot

but the Stored Proc that I am using is locked, cannot modify it, is there any other way that I could do it then, appreciate all the help

Thanks,