fnBuildTagText

    CREATE Function dbo.fnBuildTagText(@SiteContentId int)
RETURNS nvarchar(4000)
AS
BEGIN
RETURN(
    SELECT ',' + cte.Description
    FROM dbo.SiteContent sc
    INNER JOIN
    dbo.ObjectTags ot
    ON sc.Guid = ot.ObjectGuid
    INNER JOIN
    dbo.SiteCodeTableEntries cte
    ON ot.CodeTableTagID = cte.ID
    WHERE sc.ID = @SiteContentID
    FOR XML PATH('') 
)
END