Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ATG
Starting Member
35 Posts |
 Posted - 2011-12-21 : 18:10:30
|
| What i'm trying to do is merge a colum with multiple rows into one.Lets say I have a table called State that has 2 columns. State and City.STATE CITYCA San FranciscoCA San DiegoCA Los AngelesNV RenoNV Carson CityNV Las VegasI need it to display as 2 rows CA San Francisco, San Diego, Los AngelesNV Reno, Carson City, Las VegasIs this possible? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Concatenate a column with multiple rows into one