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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-29 : 08:20:02
|
| Nadaraja Yogendran writes "Hi,I need to combine values in a column.This is the exact problem-------------------------------------------------ID | PersonID |ContactID | Description -------------------------------------------------01 | 5 | 01 | 0773059744 02 | 5 | 02 | 081222696203 | 6 | 01 | 077305973304 | 6 | 02 | 081222678205 | 6 | 03 | www.sqlteam.com06 | 7 | 01 | 077305975507 | 7 | 04 | yogendrann@gmail.com-------------------------------------------------ContactID : 01-Day Phone No, 02- Evening Phone No, 03-Web, 04-Emial Address and so on.* From this table ,I need to create a table like this-------------------------------------------------ID | PersonID | Description -------------------------------------------------01 | 5 | 0773059744/0812226962 02 | 6 | 0773059733/0812226782/www.sqlteam.com03 | 7 | 0773059755/yogendrann@gmail.com-------------------------------------------------Help me on thisEmail:yogendrann@gmail.comRegards:Yogendran (yogi)" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-29 : 08:20:18
|
| A couple of solutions here:http://www.sqlteam.com/searchresults.asp?SearchTerms=csv |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How to combine multiple values