Concatenating multiple rows into a string

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Articles Requested » Concatenating multiple rows into a string

Concatenating multiple rows into a string

Rate Topic

Display Mode

Topic Options

Author

Message

spaghettidba

Posted Thursday, October 28, 2010 3:57 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 4,804, Visits: 8,074

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, haven't found one here on SSC.

I see this asked over and over on the forums.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1012166

Lynn Pettis

Posted Thursday, October 28, 2010 6:44 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:51 PM
Points: 21,627, Visits: 27,482

I'll take this one.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1012264

Steve Jones - SSC Editor

Posted Thursday, October 28, 2010 8:25 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:30 PM
Points: 31,436, Visits: 13,751

Excellent, no hurry, Lynn

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1012351

Jeff Moden

Posted Thursday, June 23, 2011 5:32 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:51 PM
Points: 32,923, Visits: 26,811

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1130874

Evil Kraig F

Posted Thursday, June 23, 2011 5:35 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:29 PM
Points: 5,688, Visits: 6,141

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1130875