USP_AMPROIMPORT_LOOKUPEVENTPRICE

Returns the ID of an event price imported from AuctionMaestro Pro.

Parameters

Parameter	Parameter Type	Mode	Description
@OPTIONNAME	nvarchar(100)	IN
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_AMPROIMPORT_LOOKUPEVENTPRICE
            (
                @OPTIONNAME as nvarchar(100),
                @EVENTID uniqueidentifier
            )
            as 
            set nocount on;

            select top 1 
                ID,
                AMOUNT,
                RECEIPTAMOUNT,
                NAME,
                REGISTRATIONCOUNT
            from dbo.EVENTPRICE
            where NAME = @OPTIONNAME and EVENTID = @EVENTID;