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 |
|
daniel50096230
Yak Posting Veteran
99 Posts |
 Posted - 2013-12-12 : 02:16:30
|
| I has the following rows in my columns:Type_IDTreatment_TimeCourse_DescriptionEffective_ToEffective_FromHow can I pivot them become the following columns and using the type_ID data as column name?Treatment_Time Course_Description Effective_To Effective_FromBy the way, the data in Type_ID column might be different, how can I make a dynamic pivot in order to cater this? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Dynamic Pivot