Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pull Multiple Phone Records On Contact Row
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01463756
Message ID:
01463759
Views:
65
Kevin, if I'm assuming correct, that you want something like this: (and sorry these numbers don't line up, I hate the way this works in the editor here)
Person (Contact)                      Home #         Office #            FAX #            Cell                 Other1            Other2            Other3
Kevin Goff                          111-2222     222-3333                                  666-1111  
John Smith                            222-3333                               444-3333        111-2222
If I'm right, this would be a use for PIVOT. Let me know if what I just described up here is what you want.

Kevin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform