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 |
|
padsp
Starting Member
21 Posts |
 Posted - 2006-11-16 : 11:01:44
|
| Hi,I have a table called phonelist with following data structure:TABLE:phonelistintphoneID intestID intcontID ctnbr(dir/fax/email)100 539 1001 123-23-4587101 539 1001 457-78-1254102 539 1001 abc@abc.com103 539 1002 458-78-6588104 554 1040 adc@dkd.comI am looking for SQL statement to produce output like this:539 1001 123-23-4587 457-78-1254 abc@abc.com539 1002 458-78-6588554 1040 adc@dkd.comThanks in advanceBob |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-16 : 20:16:08
|
| Note that if the concatenated string exceeds 8000 charactes then you need to use more than one variable. If you use front end application, do concatenation thereMadhivananFailing to plan is Planning to fail |
 |
|
|
padsp
Starting Member
21 Posts |
Posted - 2006-11-17 : 15:27:10
|
| Thank you all very much for the reply. |
|
|
|
|
|
|
Help in SQL Query!