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 |
|
kalinbac
Starting Member
6 Posts |
 Posted - 2011-06-15 : 04:13:43
|
| hi, i have two columns called Profile and ProfileCommunication.Profile Table_ID _Name _Birthday _SSN 101 John 5/12/1970 23213323103 Mary 6/3/1969 21323366105 Frank 3/5/1980 5656779ProfileCommunication Table_ID _ProfileID _CommInfo _ComType1 101 555-1434 Phone2 101 john@xxxx.com Email3 101 462-555-1243 mobile4 103 mary@xx.com Email5 103 555-7676 PhoneHere the problem comes...I want my query to retrive John's or anybody's Communication informations and show them in a single row but not in one column. I want to see each comminfo in their own column like thisName Phone Email MobileJohn 555-1434 john@xxx.com 462-555-1243Mary 555-7676 mary@xx.com ----------Any ideas? thanks for helpIf there is nothing to do, there is nothing to do... |
|
|
ArpitNarula
Starting Member
16 Posts |
Posted - 2011-06-15 : 04:48:01
|
| If I understand correctly your problen can be solved by using PIVOT.Google the syntax for PIVot. |
 |
|
|
kalinbac
Starting Member
6 Posts |
Posted - 2011-06-15 : 04:55:33
|
| i suppose pivot is used only with math functions like avg, sum, count. not for strings*If there is nothing to do, there is nothing to do...* |
|
|
|
|
|
|
Multiple rows to separate columns