USP_AMPROIMPORT_COMMITEVENT

Commits changes to an event from an AuctionMaestro Pro import batch.

Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@STARTDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_AMPROIMPORT_COMMITEVENT
            (
                @EVENTID uniqueidentifier,
                @NAME nvarchar(100),
                @STARTDATE datetime,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

            update dbo.EVENT
                set NAME = @NAME,
                    STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME(@STARTDATE),
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CHANGEDATE
            where ID = @EVENTID and (NAME <> @NAME or STARTDATE <> @STARTDATE);