Concatenating multiple rows into a string

Question

Post reply

Concatenating multiple rows into a string

spaghettidba

SSC Guru

Points: 105732
More actions
October 28, 2010 at 3:57 am

#225578

How to build a string concatenating values from multiple rows.
Example:
RowId Name
----- --------
1 Articles
2 Forums
3 Scripts
4 Surveys
Requested output:
Articles, Forums, Scripts, Surveys
There's a good article at Simple Talk[/url], haven't found one here on SSC.
I see this asked over and over on the forums.
-- Gianluca Sartori

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

October 28, 2010 at 6:44 am

#1243497

I'll take this one.

Steve Jones - SSC Editor SSC Guru Points: 736297 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736297

October 28, 2010 at 8:25 am

#1243577

Excellent, no hurry, Lynn

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 3

I believe that Wayne S. did this one already.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 4

I always point folks to this one:

http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

Craig Farrell (6/23/2011)
I always point folks to this one:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/

Ah! I didn't notice it. My bad. :blush:

Thanks for the pointer.

-- Gianluca Sartori

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 6

Craig Farrell (6/23/2011)
I always point folks to this one:
http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/

For delimited lists, I point folks to this one:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)