USP_AMPROEXPORT_GETPICKLISTDATA

            create procedure dbo.USP_AMPROEXPORT_GETPICKLISTDATA
            (
                @AUCTIONEVENTID uniqueidentifier
            )
            as
            set nocount on;

            select
                'Recognition' as [PICKLISTNAME],
                NAME as [PICKLISTTEXT], 
                AMOUNT as [PICKLISTAMOUNT]
            from dbo.EVENTPRICE 
            where EVENTID = @AUCTIONEVENTID

            union all
            select
                'ItemCategory' as [PICKLISTNAME],
                AUCTIONITEMCATEGORY.NAME as [PICKLISTTEXT],
                null as [PICKLISTAMOUNT]
            from dbo.AUCTIONITEMCATEGORY

            order by [PICKLISTNAME], [PICKLISTTEXT], [PICKLISTAMOUNT]