UFN_AMPROIMPORT_ITEMDATA_FROMBATCHROWID

            create function dbo.UFN_AMPROIMPORT_ITEMDATA_FROMBATCHROWID
            (
                @ID uniqueidentifier
            )
            returns table 
            as
            return
            (
                --Currently, the callers of this function just need the auction ID

                select top 1 
                    EVENTAUCTIONID 
                from dbo.BATCHAMPRODATA 
                inner join dbo.BATCHAMPROIMPORT on BATCHAMPRODATA.ID = BATCHAMPROIMPORT.BATCHID
                where BATCHAMPROIMPORT.ID = @ID  
            )