IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'fp_taCreateCustomerAddressWrapper'
AND type = 'P')
DROP PROCEDURE fp_taCreateCustomerAddressWrapper
GO
CREATE PROCEDURE fp_taCreateCustomerAddressWrapper
-- fp_taCreateCustomerAddressWrapper '13498', 'testaddr','DELIVERY','GWINNETT','Steve Gray','123 MAIN','','Atlant','GA','30040','123-456-7890'
@CUSTNMBR varchar(15),
@ADRSCODE varchar(15),
@SHIPMTHD varchar(15),
@TAXSCHID varchar(15),
@CNTCPRSN varchar(60),
@ADDRESS1 varchar(60),
@ADDRESS2 varchar(60),
@CITY varchar(35),
@STATE varchar(29),
@ZIPCODE varchar(10),
@PHNUMBR1 varchar(21)
AS
set transaction isolation level read uncommitted
DECLARE @O_iErrorState INT,
@oErrString VARCHAR(256),
@ErrorDesc VARCHAR(256)
SELECT @O_iErrorState = 0
EXEC taCreateCustomerAddress
@I_vCUSTNMBR = @CUSTNMBR,
@I_vADRSCODE = @ADRSCODE,
@I_vSHIPMTHD = @SHIPMTHD,
@I_vTAXSCHID = @TAXSCHID,
@I_vCNTCPRSN = @CNTCPRSN,
@I_vADDRESS1 = @ADDRESS1,
@I_vADDRESS2 = @ADDRESS2,
@I_vCITY = @CITY,
@I_vSTATE = @STATE,
@I_vZIPCODE = @ZIPCODE,
@I_vPHNUMBR1 = @PHNUMBR1,
@O_iErrorState = @O_iErrorState OUT,
@oErrString = @oErrString OUT
IF @O_iErrorState > 0 BEGIN
SELECT @ErrorDesc = tec.ErrorDesc
FROM dynamics..taErrorCode tec
WHERE tec.ErrorCode = @O_iErrorState
END ELSE BEGIN
SELECT @ErrorDesc = ''
end
SELECT @O_iErrorState AS ErrorState, @oErrString AS ErrString, @ErrorDesc AS ErrorDesc
-- fp_taCreateCustomerAddressWrapper '13498', 'testaddr','DELIVERY','GWINNETT','Steve Gray','123 MAIN','','Atlant','GA','30040','123-456-7890'
GO
grant exec on fp_taCreateCustomerAddressWrapper to public
-- sp_sps 't'