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 |
|
memarcie
Yak Posting Veteran
91 Posts |
 Posted - 2007-08-09 : 14:34:01
|
| I'm trying to query providers and their specialties however a provider may have more than one specialtyie:prov_num Specialty 1 pediatrics 2 acute 2 radiology 3 dentistryI want to query each provider and then list their specialties after the provider num. so I want to see1 pediatrics2 acute, radiology3 dentistryI've done something like this a while ago, but can't remember how to do it now or what it is even called so I don't know what to search on. (derived column maybe?)Thanks for your help!Marcie |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
How to combine rows into one column