I'm getting closer, I think I may have it. I've wrestled this down to this result with query results to text:

ORDER_NUMBER DESCRIPTION

--------------------- ------------------------------

451093.00

Line 1 Description

Line 2 Description

[font="Courier New"]

WITH CTE AS

(

SELECT DISTINCT

ORDER_NUMBER

FROM Order_Lines

WHERE ORDER_NUMBER = '451093.00'

)

SELECT ORDER_NUMBER,

[DESCRIPTION] = STUFF((

SELECT (CHAR(13) + CHAR(10)) + [DESCRIPTION]

FROM Order_Lines

WHERE ORDER_NUMBER = CTE.ORDER_NUMBER

ORDER BY LINE_NUMBER

FOR XML PATH(''),

TYPE).value('.','varchar(max)'),1,1,'')

FROM CTE

ORDER BY ORDER_NUMBER;

[/font]