Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to concatentate a table column to a string?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-12-04 : 08:02:04
Michael writes "How can i flatten a column of a table in a string?
e.g. (Select ID from mytable) will return a column with all
available ids.
I want to put all this ids in a string with a delimiter(e.g. ',').
Up to now the only solution i can think is with a cursor, but i would like to use something less expensive....

Any suggestion? thanks michael"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-12-04 : 08:02:26
Take a look at these:

http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv
Go to Top of Page
   

- Advertisement -