Emp ID 11-Jan-12 12-Jan-12
Total Special Tasks Total Special Tasks
499003 166.1 8 155.7 9
210009 170.2 9 178.1 7
I want to get data in the above format using the PIVOT?
Currently I have a huge data in the below format. Nearly 50 EmpIDs for 30 days (dates)
Emp ID Date Total specialtasks
499003 11-Jan-12 166.1 8
499003 12-Jan-12 155.7 9
210009 11-Jan-12 170.2 9
210009 12-Jan-12 178.1 7
please help
Total Special Tasks Total Special Tasks
499003 166.1 8 155.7 9
210009 170.2 9 178.1 7
I want to get data in the above format using the PIVOT?
Currently I have a huge data in the below format. Nearly 50 EmpIDs for 30 days (dates)
Emp ID Date Total specialtasks
499003 11-Jan-12 166.1 8
499003 12-Jan-12 155.7 9
210009 11-Jan-12 170.2 9
210009 12-Jan-12 178.1 7
please help