|
I want to combine multiple text by id till next id into
(comments are locked)
|
|
Will the approach at the bottom of this article work? http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string
(comments are locked)
|
|
Here's another method: http://blogs.perkinsconsulting.com/post/Concatenating-Strings-in-SQL-without-a-Loop.aspx Note that this method wont work for multiple rows as OP specified
Oct 14 '09 at 09:27 AM
Madhivanan
(comments are locked)
|
Your answer
John, if you use one of these methods can you mark one of the answers as the one you accepted?
I see that many people simply ask questions and dont follow them