Home Forums SQL Server 2005 Development Need to merge multiple rows into one with carriage return RE: Need to merge multiple rows into one with carriage return

  • try this

    ;WITH cte AS

    (

    SELECT DISTINCT ID

    FROM @Sample

    )

    SELECT cte.ID, Z.Descriptions

    FROM cte

    CROSS APPLY

    (

    SELECT (STUFF((SELECT CHAR(13) + Description

    FROM @Sample AS Sample

    WHERE Sample.ID = cte.ID

    FOR XML PATH(''), TYPE).value('.[1]', 'varchar(MAX)'), 1, 1, ''))

    ) AS Z (Descriptions)