USP_DATALIST_AUCTIONITEMBATCHLOOKUPID

Allows auction item batch to lookup the Lookup ID for a constituent or lookup the constituent for a lookup ID.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_AUCTIONITEMBATCHLOOKUPID
                (
                    @LOOKUPID nvarchar(100) = null,
                    @CONSTITUENTID uniqueidentifier = null
                )
                as
                set nocount on;

                if @LOOKUPID is null or @LOOKUPID = ''
                begin
                    select 
                        CONSTITUENT.LOOKUPID,
                        CONSTITUENT.ID,
                        CONSTITUENT.NAME,
                        CONSTITUENT.GIVESANONYMOUSLY
                    from 
                        dbo.CONSTITUENT 
                    where 
                        CONSTITUENT.ID = @CONSTITUENTID

                    union

                    select
                        '',
                        BATCHAUCTIONITEMCONSTITUENT.ID,
                        BATCHAUCTIONITEMCONSTITUENT.NAME,
                        BATCHAUCTIONITEMCONSTITUENT.GIVESANONYMOUSLY
                    from
                        dbo.BATCHAUCTIONITEMCONSTITUENT
                    where
                        BATCHAUCTIONITEMCONSTITUENT.ID = @CONSTITUENTID;
                end
                else
                begin
                    select 
                        CONSTITUENT.LOOKUPID,
                        CONSTITUENT.ID,
                        CONSTITUENT.NAME,
                        CONSTITUENT.GIVESANONYMOUSLY
                    from dbo.CONSTITUENT 
                    where CONSTITUENT.LOOKUPID = @LOOKUPID;
                end