compile sql server online

Language: Layout:

--Title of this code
--Batches are separated by 'go'

select @@version as 'sql server version'

CREATE TABLE A ( ID int PRIMARY KEY,
	ADate datetime,
	)

INSERT INTO A VALUES (1,'2014-01-20')
	INSERT INTO A VALUES (2,'2014-02-20')
	INSERT INTO A VALUES (3,'2014-03-20')
	INSERT INTO A VALUES (4,'2014-04-20')
	INSERT INTO A VALUES (5,'2014-05-20')
	INSERT INTO A VALUES (6,'2014-06-20')
	INSERT INTO A VALUES (7,'2014-07-20')
	INSERT INTO A VALUES (8,'2014-08-20')
	INSERT INTO A VALUES (9,'2014-09-20')
	INSERT INTO A VALUES (10,'2014-10-20')
	INSERT INTO A VALUES (11,'2014-11-20')
	INSERT INTO A VALUES (12,'2014-12-20')

CREATE TABLE B (
		ID int ,
		IDA int FOREIGN KEY REFERENCES A(ID),		
		Value decimal(22,6),
		PRIMARY KEY(IDA,ID)
)

INSERT INTO B(ID,IDA,Value) VALUES(1,1,10)
    INSERT INTO B(ID,IDA,Value) VALUES(2,1,10)
    INSERT INTO B(ID,IDA,Value) VALUES(3,1,10)
	INSERT INTO B(ID,IDA,Value) VALUES(4,1,10)
	INSERT INTO B(ID,IDA,Value) VALUES(5,1,10)
	INSERT INTO B(ID,IDA,Value) VALUES(6,1,10)
	INSERT INTO B(ID,IDA,Value) VALUES(7,1,10)
	INSERT INTO B(ID,IDA,Value) VALUES(8,1,10)
	INSERT INTO B(ID,IDA,Value) VALUES(1,2,9)
    INSERT INTO B(ID,IDA,Value) VALUES(2,2,9)
    INSERT INTO B(ID,IDA,Value) VALUES(3,2,9)
	INSERT INTO B(ID,IDA,Value) VALUES(4,2,9)
	INSERT INTO B(ID,IDA,Value) VALUES(5,2,9)
	INSERT INTO B(ID,IDA,Value) VALUES(6,2,9)
	INSERT INTO B(ID,IDA,Value) VALUES(7,2,9)
	INSERT INTO B(ID,IDA,Value) VALUES(8,2,9)
	INSERT INTO B(ID,IDA,Value) VALUES(1,3,8)
    INSERT INTO B(ID,IDA,Value) VALUES(2,3,8)
    INSERT INTO B(ID,IDA,Value) VALUES(3,3,8)
	INSERT INTO B(ID,IDA,Value) VALUES(4,3,7)
	INSERT INTO B(ID,IDA,Value) VALUES(5,3,7)
	INSERT INTO B(ID,IDA,Value) VALUES(6,3,8)
	INSERT INTO B(ID,IDA,Value) VALUES(7,3,8)
	INSERT INTO B(ID,IDA,Value) VALUES(8,3,7)
	INSERT INTO B(ID,IDA,Value) VALUES(1,4,6)
    INSERT INTO B(ID,IDA,Value) VALUES(2,4,5)
    INSERT INTO B(ID,IDA,Value) VALUES(3,4,6)
	INSERT INTO B(ID,IDA,Value) VALUES(4,4,5)
	INSERT INTO B(ID,IDA,Value) VALUES(5,4,6)
	INSERT INTO B(ID,IDA,Value) VALUES(6,4,5)
	INSERT INTO B(ID,IDA,Value) VALUES(7,4,6)
	INSERT INTO B(ID,IDA,Value) VALUES(8,4,5)

INSERT INTO B(ID,IDA,Value) VALUES(1,5,2)
    INSERT INTO B(ID,IDA,Value) VALUES(2,5,2)
    INSERT INTO B(ID,IDA,Value) VALUES(3,5,3)
	INSERT INTO B(ID,IDA,Value) VALUES(4,5,4)
	INSERT INTO B(ID,IDA,Value) VALUES(5,5,2)
	INSERT INTO B(ID,IDA,Value) VALUES(6,5,2)
	INSERT INTO B(ID,IDA,Value) VALUES(7,5,3)
	INSERT INTO B(ID,IDA,Value) VALUES(8,5,4)
	INSERT INTO B(ID,IDA,Value) VALUES(1,6,5)
    INSERT INTO B(ID,IDA,Value) VALUES(2,6,5)
    INSERT INTO B(ID,IDA,Value) VALUES(3,6,5)
	INSERT INTO B(ID,IDA,Value) VALUES(4,6,5)
	INSERT INTO B(ID,IDA,Value) VALUES(5,6,5)
	INSERT INTO B(ID,IDA,Value) VALUES(6,6,5)
	INSERT INTO B(ID,IDA,Value) VALUES(7,6,5)
	INSERT INTO B(ID,IDA,Value) VALUES(8,6,5)
	INSERT INTO B(ID,IDA,Value) VALUES(1,7,1)
    INSERT INTO B(ID,IDA,Value) VALUES(2,7,2)
    INSERT INTO B(ID,IDA,Value) VALUES(3,7,3)
	INSERT INTO B(ID,IDA,Value) VALUES(4,7,4)
	INSERT INTO B(ID,IDA,Value) VALUES(5,7,5)
	INSERT INTO B(ID,IDA,Value) VALUES(6,7,6)
	INSERT INTO B(ID,IDA,Value) VALUES(7,7,7)
	INSERT INTO B(ID,IDA,Value) VALUES(8,7,8)
	INSERT INTO B(ID,IDA,Value) VALUES(1,8,6)
    INSERT INTO B(ID,IDA,Value) VALUES(2,8,5)
    INSERT INTO B(ID,IDA,Value) VALUES(3,8,6)
	INSERT INTO B(ID,IDA,Value) VALUES(4,8,5)
	INSERT INTO B(ID,IDA,Value) VALUES(5,8,6)
	INSERT INTO B(ID,IDA,Value) VALUES(6,8,5)
	INSERT INTO B(ID,IDA,Value) VALUES(7,8,6)
	INSERT INTO B(ID,IDA,Value) VALUES(8,8,5)
    
    
    
SELECT 
    ID, 
    [1] as Ian, 
    [2] as Feb, 
    [3] as Mar, 
    [4] as Apr,
    [5] as Mai,
    [6] as Iun,
    [7] as Iul,
    [8] as Aug,
    [9] as Sept,
    [10] as Oct,
    [11] as Noe,
    [12] as Dec
FROM b
PIVOT
(
  SUM(Value) 
  FOR IDA IN ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12])
) AS ResultTable

View schema
Execution time: 0.05 sec, rows selected: 9, rows affected: 76, absolute service time: 0.3 sec