Combining text data from multiple rows into single cell

[schusser]

Hi all!
I'm trying to read data like...
Company State Sales
ABC MA 20000
ABC RI 3500
ABC IL 650000
XYZ VT 4500
XYZ FL 75000
XYZ CA 55000
and want the result to be...
ABC MA, RI, IL 673500
XYZ VT, FL, CA 134500
I can get the Sales OK, but how can I get the State to be right?

Thanks in advance for your help!

 

[mrdenny]

You'll need to use a function with a cursor in it to do that.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com