UFN_REVENUE_BUILDSITELIST_BULK

Returns comma delimited lists of sites associated with revenue records.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_REVENUE_BUILDSITELIST_BULK()
            returns table
            as
            return
            (
                select
                    REVENUE.ID,
                    convert(nvarchar(1024), (
                        select dbo.UDA_BUILDLIST(SITE.NAME)
                        from dbo.SITE
                        where SITE.ID in (
                            select REVENUESPLITSITE.SITEID
                            from dbo.REVENUESPLIT
                                cross apply dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(REVENUESPLIT.ID) REVENUESPLITSITE
                            where REVENUESPLIT.REVENUEID = REVENUE.ID
                        )
                    )) as SITES
                from dbo.REVENUE
            )