Getting closer:

Using

SELECT

ID,

[Description] = MAX(o.list)

FROM

@Sample T1

CROSS APPLY

(

SELECT ISNULL([Description], '' ) AS [data()]

FROM @Sample T2

WHERE T2.ID = T1.ID

FOR XML PATH ('')

)o(list)

GROUP BY ID

My results come out: (Using results to text)

1234 I love sql server

3234 i despise oracle

How do I add a carriage return, so my output looks like this:

1234 I

love

sql server

3234 i

despise

oracle