To convert rows into CSV format

Question

Post reply

To convert rows into CSV format

Shree-903371

SSCommitted

Points: 1930
More actions
October 13, 2008 at 2:35 pm

#192053

Hi, I have two fields State and City in one table. When I select I get
STATE CITY
Connecticut Hartford
Connecticut Stamford
Connecticut New Haven
Connecticut Bridgeport
But I need in CSV format, like
ConnecticutHartford, Stamford, New Haven, Bridgeport
There are many cities for some states. At my work place we can’t use dynamic sql. So can anybody suggest me the best way to do it?

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

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

Ak-763166 Right there with Babe Points: 772 More actions · Answer 1

please refer to this link. It might be helpful:

http://www.sqlservercentral.com/articles/Test+Data/61572/

Also refer

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

Shree-903371 SSCommitted Points: 1930 More actions · Answer 2

Hi, I tried the first one but its not working. Its giving me null values. The other one I already tried but didn’t work as my database is in 2000, so I can’t use XML path.