USP_AMPROIMPORT_SETBATCHDATA

Associates data from an AuctionMaestro Import with a batch.

Parameters

Parameter	Parameter Type	Mode
@BATCHID	uniqueidentifier	IN
@EVENTAUCTIONID	uniqueidentifier	IN
@IMPORTGENERATED	datetime	IN
@IMPORTDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_AMPROIMPORT_SETBATCHDATA
            (
                @BATCHID uniqueidentifier,
                @EVENTAUCTIONID uniqueidentifier,
                @IMPORTGENERATED datetime,
                @IMPORTDATE datetime,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

            insert into dbo.BATCHAMPRODATA(ID, EVENTAUCTIONID, IMPORTGENERATED, IMPORTDATE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values(@BATCHID, @EVENTAUCTIONID, @IMPORTGENERATED, @IMPORTDATE, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);


            return 0;