USP_AMPROEXPORT_GETAUCTIONDATA

            CREATE procedure dbo.USP_AMPROEXPORT_GETAUCTIONDATA
            (
                @AUCTIONEVENTID uniqueidentifier
            )
            as
            set nocount on;

            declare @SEQUENCEIDOFFSET int = 9999999;

            select 
                EVENTAUCTION.SEQUENCEID - @SEQUENCEIDOFFSET as [SEQUENCEID],
                EVENTAUCTION.ID,
                EVENTAUCTION.LOOKUPID,
                EVENT.NAME,
                (select DESCRIPTION from dbo.EVENTCATEGORYCODE where EVENTCATEGORYCODE.ID = EVENT.EVENTCATEGORYCODEID) as [EVENTCATEGORY],
                EVENT.STARTDATETIME,
                (select top 1 INSTALLATIONNAME from dbo.INSTALLATIONINFO) as [ORGNAME],
                EVENT.BASECURRENCYID as [EVENTBASECURRENCYID]
            from EVENTAUCTION
            inner join dbo.EVENT on EVENT.ID = EVENTAUCTION.ID
            where EVENTAUCTION.ID = @AUCTIONEVENTID;