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 |
|
pssumesh2003
Starting Member
35 Posts |
 Posted - 2010-03-22 : 06:56:38
|
| Hi everybody,In one of my project a table likeTID Location1 Newyork2 Sidney2 Tokyo2 Berlin1 Mumbai3 Beijingi wnat a query to select above table asTID Newcolumn----- ---------1 Newyork,Mumbai2 Sidney,Tokyo,Berlin3 BijingPlz help me? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-22 : 06:59:51
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254MadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Multiple rows into a single row