UFN_AMPROIMPORT_LOOKUPEVENT

Returns the ID from EVENTAUCTION for an auction found in AuctionMaestro Pro.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@LOOKUPID	nvarchar(100)	IN

Definition

Copy



            create function dbo.UFN_AMPROIMPORT_LOOKUPEVENT
            (
                @LOOKUPID nvarchar(100)
            )
            returns uniqueidentifier
            as
            begin
                declare @R uniqueidentifier = null;

                select top 1
                    @R = ID
                from dbo.EVENTAUCTION
                where EVENTAUCTION.LOOKUPID = @LOOKUPID
                order by DATEADDED;

                return @R;
            end