| EmpCode | month | salary |
| 1 | Feb2015 | 32000 |
| 1 | march2015 | 32000 |
| 2 | Feb2015 | 41000 |
| 3 | feb2015 | 30000 |
| 3 | march2015 | 30000 |
i want result set like:-
| EmpCode | Jan2015 | Feb2015 | March2015 |
| 1 | null | 32000 | march2015 |
| 2 | null | 41000 | null |
| 3 | null | 30000 | 30000 |
pivot in sql server
I have a salary table like:-
Nilesh SawardekarPosted Jul 25, 2016, 4:06 AM