Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pull Multiple Phone Records On Contact Row
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01463756
Message ID:
01463759
Vues:
67
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform