May 14, 2014 at 12:16 pm
I am trying to pivot the table to sql server 2008 R2.
source excel file is like this.
date 1/1/2000 2/1/2000
money 5 7
name Julie tom
I want to make the first column on the top row as a column names.
date money name
1/1/2000 5 Julie
2/1/2000 7 tom
what is the easiest way? ssis pivot transformation? SQL code? thank you!
May 14, 2014 at 12:39 pm
Create an intermediate table for the data from Excel then use UNPIVOT.
May 15, 2014 at 12:27 am
jjkool (5/14/2014)
I am trying to pivot the table to sql server 2008 R2.source excel file is like this.
date 1/1/2000 2/1/2000
money 5 7
name Julie tom
I want to make the first column on the top row as a column names.
date money name
1/1/2000 5 Julie
2/1/2000 7 tom
what is the easiest way? ssis pivot transformation? SQL code? thank you!
Depends on what you are most familiar with. Writing a SQL query or using the confusing UNPIVOT transformation.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply