UFN_EVENTAUCTION_GETSITELIST

            CREATE function dbo.UFN_EVENTAUCTION_GETSITELIST
            (
                @EVENTAUCTIONID uniqueidentifier
            )
            returns nvarchar(500)
            as begin

                declare @SITES nvarchar(500) = null;

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

                return @SITES;
            end