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

sql server dynamic 12 month time series and pivot with month year colu...

Language: Layout:
View schema
Execution time: 0,08 sec, rows selected: 11, rows affected: 33, absolute service time: 0,25 sec 
fork mode |  history  | discussion
   id Nov 2015 Dec 2015 Jan 2016 Feb 2016 Mar 2016 Apr 2016 May 2016 Jun 2016 Jul 2016 Aug 2016 Sep 2016 Oct 2016
1 1 0 0 1 0 0 0 0 0 0 0 0 1
2 2 1 0 0 1 0 0 0 0 0 0 0 0
3 3 0 1 0 0 1 0 0 0 0 0 0 0
4 4 0 0 0 0 0 1 0 0 0 0 0 0
5 5 0 0 0 0 0 0 1 0 0 0 0 0
6 6 0 0 0 0 0 0 0 1 0 0 0 0
7 7 0 0 0 0 0 0 0 0 1 0 0 0
8 8 0 0 0 0 0 0 0 0 0 1 0 0
9 9 0 0 0 0 0 0 0 0 0 0 1 0

    
                
Advertise here.