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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2011-08-08 : 11:12:28
|
| Hi All,I am generatinig report having customised emp column. my sql returing me the out put as belowEmp ID Salary Deduc10010 2000 10010011 3500 15010012 4000 25010013 1200 100Is it possible in sql to use multiple pivot (one for Emp ID and salary) and another for Emp ID and Deduc) to get below customised output?Sal-10010 Sal-10011 Sal-10012 Sal-10013 Ded-10010 Ded-10011 Ded-10012 Ded-100132000 3500 4000 1200 100 150 250 100Please help me out.T.I.A |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Multiple pivot statement in single query?