UFN_REVENUESPLIT_BUILDSITELIST

Returns a comma delimited list of sites associated with the given revenue split.

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUESPLIT_BUILDSITELIST(
                @REVENUESPLITID uniqueidentifier
            )
            returns nvarchar(1024)
            as
            begin
                declare @SITES nvarchar(1024) = (select dbo.UDA_BUILDLIST(SITE.NAME)
                    from dbo.UFN_SITEID_MAPFROM_REVENUESPLITID(@REVENUESPLITID) REVENUESPLITSITE
                        inner join dbo.SITE on SITE.ID = REVENUESPLITSITE.SITEID
                );

                return @SITES;            
            end