UFN_AUCTIONPACKAGE_GETDESIGNATIONLIST

Returns a distinct list of designation names for all items in the package.

Return

Return Type
nvarchar(3000)

Parameters

Parameter	Parameter Type	Mode	Description
@AUCTIONPACKAGEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_AUCTIONPACKAGE_GETDESIGNATIONLIST
            (
                @AUCTIONPACKAGEID uniqueidentifier
            )
            returns nvarchar(3000)
            as begin

                declare @DESIGNATIONS nvarchar(3000) = null;

                select 
                    @DESIGNATIONS = dbo.UDA_BUILDLIST(DISTINCT DESIGNATION.NAME)
                from
                    dbo.AUCTIONITEM
                    left join dbo.REVENUESPLIT on AUCTIONITEM.REVENUEAUCTIONDONATIONID = REVENUESPLIT.REVENUEID
                    left join dbo.DESIGNATION on REVENUESPLIT.DESIGNATIONID = DESIGNATION.ID
                where
                    AUCTIONITEM.PACKAGEID = @AUCTIONPACKAGEID

                return @DESIGNATIONS;
            end