UFN_AMPROIMPORT_EVENTDATA

Returns event data for AuctionMaestro Pro imports for events already in the system.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTAUCTIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_AMPROIMPORT_EVENTDATA
            (
                @EVENTAUCTIONID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    EVENT.NAME,
                    EVENT.STARTDATETIME as [STARTDATE],
                    EVENT.ENDDATETIME as [ENDDATE]
                from dbo.EVENT
                inner join dbo.EVENTAUCTION on EVENTAUCTION.ID = EVENT.ID
                where EVENTAUCTION.ID = @EVENTAUCTIONID
            )