Hah, Getting this question again :) Well, I used to suggest a set based
approach to solve this problem but I was slapped left, right and centre by
the experts in this group to show that it will fail.. And I am happy that
they did :) Some things never get into our head unless forced...
Coming to answer your question, you can use a cursor to loop through the
records and manually concatenate each row, if you are using SQL Server 2000.
And that is the only, I repeat, only approach that will work..
For approaches on SQL Server 2005 (using for XML Path) and pitfalls with
other approaches you might have come across in SQL Server 2000, you may check
-Omnibuzz (The SQL GC)