Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Blog 

Pivot a table in SQL Server that contains yearly data

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 10, absolute service time: 0,19 sec 
edit mode |  history
   ExpenseType 2015 2016 2017
1 Food 85,00 27,50 51,00
2 Furniture 540,00 0,00 0,00
3 Gasoline 48,40 0,00 50,30
4 Rent 335,00 340,50 340,50