SQL convert 1 column's values to 1 row string

Question

Post reply

SQL convert 1 column's values to 1 row string

Viewing 5 posts - 16 through 19 (of 19 total)

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

ismail casper SSCrazy Points: 2003 More actions · Answer 1

My Apologies, Sql Server 2000 (80)

I assumed that i was using Management Studio, but connecting to a DB on the SQL2000 server

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 2

If the code is going to have to run under SQL 2000, then FOR XML isn't an option. At least you have a solution which is satisfactory for your purposes.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

Now, wait a minute... concatenation is usually a mistake. What is this for (ie, business reasons other than "it's a requirement") and why do you need to do it on the server side? I ask only because there may be a better way lurking in the corner if we knew more about the business reasons.

--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)

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 4

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Jeff Moden SSC Guru Points: 1004558 More actions · Answer 5

Bob Hovious (4/22/2009)

Heh... nope... not stalking. :hehe:

--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)

SQL convert 1 column's values to 1 row string

Cookies on SQLServerCentral