• The SELECT :

    SELECT

    1 as Tag,

    null as Parent,

    [NewsTitle],

    [NewsSummary],

    LEFT(DATENAME(dw, [NewsDate]),3) + ', ' + STUFF(CONVERT(nvarchar,[NewsDate],113),21,4,' GMT')

    FROM [sd_News] WHERE [IDChannel] = '11'

    With the FOR XML :

    SELECT

    1 as Tag,

    null as Parent,

    [NewsTitle] as [item!1!title!ELEMENT],

    [NewsSummary] as [item!1!description!CDATA],

    LEFT(DATENAME(dw, [NewsDate]),3) + ', ' + STUFF(CONVERT(nvarchar,[NewsDate],113),21,4,' GMT') as [item!1!pubDate!ELEMENT]

    FROM [sd_News] WHERE [IDChannel] = '11'

    FOR XML EXPLICIT

    After some tests, it seems that the problem occurs when the HTML data store in the column NewsSummary is very important.

    Regards.