No probs - it's an interesting thread.
To get the maximum response, I suggest that you create a new thread in the T-SQL forum specifically with this requirement, eg
Given the following data:
OrderID, ProductID, ItemPrice
1,1000,50.00
1,1001,75.00
2,1000,50.00
3,1001,75.00
3,1002,95.00
3,1003,44.00
How can I write a SELECT statement to return the following:
OrderID, ProductID, ItemPrice
1,1000,50.00, NULL
1,1001,75.00, crlf
2,1000,50.00, crlf
3,1001,75.00, NULL
3,1002,95.00, NULL
3,1003,44.00, crlf
where crlf = CHAR(13) + CHAR(10)?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.