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:18:42
|
| 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... |
|
|
kalinbac
Starting Member
6 Posts |
Posted - 2011-06-15 : 04:22:07
|
I used Subquery to get the CommInfo one by one and i have them in one row with separate columns, But i cant use Group By function because of Subquery in the Select If there is nothing to do, there is nothing to do... |
 |
|
|
|
|
|
PIVOT LIKE QUERY