UFN_AUCTIONPACKAGE_GETSITELIST

Returns a semi-colon delimited list of sites related to the auction attached to the package.

Return

Return Type
nvarchar(500)

Parameters

Parameter	Parameter Type	Mode	Description
@AUCTIONPACKAGEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_AUCTIONPACKAGE_GETSITELIST
            (
                @AUCTIONPACKAGEID uniqueidentifier
            )
            returns nvarchar(500)
            as begin

                declare @SITES nvarchar(500) = null;

                select 
                    @SITES = dbo.UDA_BUILDLIST(SITE.NAME)
                from
                    dbo.AUCTIONITEM
                    left join dbo.EVENTSITE on AUCTIONITEM.EVENTAUCTIONID = EVENTSITE.EVENTID
                    left join dbo.SITE on EVENTSITE.SITEID = SITE.ID
                where
                    AUCTIONITEM.ID = @AUCTIONPACKAGEID

                return @SITES;
            end