UFN_REVENUESPLIT_BUILDSITELIST_BULK

Returns comma delimited lists of sites associated with revenue splits.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_REVENUESPLIT_BUILDSITELIST_BULK()
            returns table
            as
            return
            (
                select
                    REVENUESPLIT.ID,
                    convert(nvarchar(1024), (
                        select
                            dbo.UDA_BUILDLIST(SITE.NAME)
                        from dbo.UFN_SITEID_MAPFROM_REVENUESPLITID_BULK() REVENUESPLITSITE
                        inner join dbo.SITE on SITE.ID = REVENUESPLITSITE.SITEID
                        where REVENUESPLITSITE.ID = REVENUESPLIT.ID
                    )) as SITES
                from
                    dbo.REVENUESPLIT
            )