UFN_PDCOMPOSITESEGMENT_TABLENAMESTRING

Returns a string of tables that form the composite segment.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@Comma	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_PDCOMPOSITESEGMENT_TABLENAMESTRING(@ID uniqueidentifier, @Comma tinyint)
returns nvarchar(max)
with execute as caller
as begin

declare @retString nvarchar(max)
    if @Comma = 1 
        select @retString = isnull(@retString+', ','') + FRIENDLYTABLENAME
        from  dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT 
        join dbo.PDCOMPOSITESEGMENTTABLELIST  on PDCOMPOSITESEGMENTTABLELIST.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = PDACCOUNTTABLESAVAILABLEFORSEGMENT.ID
        where PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = @ID
    else
        select @retString = isnull(@retString+' + ','') + FRIENDLYTABLENAME
        from  dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT 
        join dbo.PDCOMPOSITESEGMENTTABLELIST  on PDCOMPOSITESEGMENTTABLELIST.PDACCOUNTTABLESAVAILABLEFORSEGMENTID = PDACCOUNTTABLESAVAILABLEFORSEGMENT.ID
        where PDCOMPOSITESEGMENTTABLELIST.PDCOMPOSITESEGMENTID = @ID    
return @retString
end