Recursive Monthly Dates By Year with Pivot, Sql Server

Language: Layout:

IF OBJECT_ID('dbo.mydata', 'U') IS NOT NULL 
  DROP TABLE dbo.mydata; 
  
CREATE TABLE mydata (
    mytype VARCHAR(20),
    mynum NUMERIC(6,4),
    mychar VARCHAR(3),
    mydate DATE
);
  
INSERT INTO mydata VALUES ('mysql',45.2707,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',91.5861,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',77.9822,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',85.5323,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2', 5.8967,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',54.8832,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',63.0003,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',68.3834,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',30.7427,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',98.9217,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',29.7813,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',97.0466,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',30.0664,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',27.6271,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',66.1275,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',83.3873,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',32.3265,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql', 1.8472,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',17.9318,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',41.1535,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server', 4.6209,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',81.6313,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',47.1262,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',55.6534,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',38.5642,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres', 7.2746,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',97.9196,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',89.7996,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',96.6379,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',80.1203,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',98.8097,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',54.6743,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',70.1591,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',73.2635,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',33.6310,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql', 4.7905,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',99.2243,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',51.8137,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',41.0709,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',22.0057,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',77.6216,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',12.9395,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',52.6506,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',24.0093,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',31.9740,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',93.6116,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',18.8313,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',19.3405,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',38.5261,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',70.0422,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',51.4506,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',55.1055,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',51.0324,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',37.1497,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',21.8041,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',41.3680,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',93.6538,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',31.5425,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server', 8.3498,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',12.9341,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',25.3695,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',98.5550,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',30.1480,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',17.4887,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',20.6891,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',96.0081,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',49.8842,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',85.2467,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',59.8683,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',94.8089,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',90.1310,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',11.5873,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',42.5201,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',38.3718,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2', 4.3078,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',30.9491,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',49.8390,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2', 0.3575,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',67.3084,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',25.7574,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',89.0479,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',34.7756,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',13.1568,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',64.9346,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',86.5519,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',32.2180,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',49.7098,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',13.7074,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle', 1.3257,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server', 6.8198,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',43.4432,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',64.5721,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',54.2627,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',62.9932,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',74.6414,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',98.1167,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',13.2146,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',77.1506,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',17.2117,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',44.0368,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',10.9457,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',10.1721,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',24.0579,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',84.3823,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',14.0120,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',83.3977,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',64.5314,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server', 7.6367,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',51.9025,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',39.2406,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',74.8608,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',15.9470,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',85.6444,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',39.3981,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',65.8543,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',67.8570,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',59.8173,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',14.2529,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',46.7769,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',26.6576,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',60.4502,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',67.4196,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',48.4639,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',59.1352,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',68.8345,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',71.0135,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',77.6257,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',22.5657,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',31.7381,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',66.1975,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',74.7823,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite', 8.4561,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres', 0.1811,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',62.9800,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',55.9591,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',69.1318,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',68.6553,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',45.0918,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',79.4204,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',85.3656,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',41.9293,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle', 3.2126,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',57.8697,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',22.7797,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',61.0464,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',82.9362,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',18.1813,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',31.4266,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',69.7631,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',13.9078,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',18.8785,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',60.9265,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',50.3439,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',91.9121,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',70.1615,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',39.9692,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',82.7973,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',42.2006,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',93.8897,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',44.3421,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',99.1503,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',69.2002,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',81.9512,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',46.5929,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',61.6102,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',73.5513,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',18.8194,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',34.6312,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',88.0781,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',58.9088,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',14.3530,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',22.4656,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',71.7500,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',82.2265,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',26.8759,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',34.5666,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',15.0464,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',62.4049,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',74.0878,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',64.6526,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',44.8790,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',19.4981,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',92.4332,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite', 4.0699,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',55.7032,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',71.4648,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',66.6812,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',91.6321,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',95.0011,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',20.8349,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2', 0.7266,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',23.1739,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',93.1122,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',87.7842,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',85.3137,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',70.9266,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',87.4074,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',82.3888,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',43.4090,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',51.1235,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql', 0.3891,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2', 1.2451,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',61.6690,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',18.2231,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',96.0382,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',27.4246,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',56.1394,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',46.8733,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',16.2743,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server', 4.0699,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',42.7457,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',21.5972,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',74.8252,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',38.3650,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',48.4791,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',32.2428,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',29.5663,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',59.2813,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',85.5048,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',77.2079,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',86.8756,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',77.0074,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',53.3742,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',78.4049,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',12.8057,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',92.2493,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',19.9465,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2', 8.1688,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',23.3726,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',39.8343,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',74.8489,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite', 2.9011,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',27.3494,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',26.2064,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',55.7277,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',85.8770,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',18.4122,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',90.0779,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',67.6411,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',78.3877,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',38.1750,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',50.0020,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',50.4448,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',34.8891,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',35.4615,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',86.1544,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',97.0965,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',77.1839,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',58.8125,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',52.0865,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',76.1286,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',72.5634,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',40.0809,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2', 0.9477,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',86.4392,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',24.9299,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',66.9090,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',27.6135,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',90.8810,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',58.7590,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',83.6755,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',18.0883,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',77.0011,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',41.2413,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',29.0018,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',45.5509,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',84.0594,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',12.1838,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql', 3.3802,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',98.0085,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',84.0520,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',42.1462,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',37.0094,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',96.7644,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',97.8666,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',90.5888,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',88.0240,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',15.1620,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',65.8540,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',17.7705,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',88.9991,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',74.9447,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',94.9489,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',96.2030,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',38.1640,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',75.1992,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',32.7375,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',57.3434,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',94.0334,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',63.1859,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',97.0662,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',47.2083,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',52.5701,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',52.8263,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',24.9201,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',51.6110,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',35.4529,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',40.3071,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',38.6522,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',60.4023,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',70.0937,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',92.8076,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',31.7851,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',32.0661,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',77.7555,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql', 4.1431,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',64.8001,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server', 6.4231,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',46.5687,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',19.6242,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',30.9198,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',41.7275,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',16.1795,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',24.5337,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',86.6012,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',58.7245,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',12.6235,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',54.3465,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql', 4.7453,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',17.3441,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',55.9609,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',13.6648,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',79.8152,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',14.7342,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',28.9359,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',59.3029,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',99.8567,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',27.1131,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',80.2945,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',17.8906,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',43.5417,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',60.9465,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',16.8619,'6Uy','2018-04-01');
INSERT INTO mydata VALUES ('sqlite',18.9633,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',72.8035,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',86.4642,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',76.5504,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',48.4259,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',95.7042,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server', 3.6471,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',35.7492,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',15.2665,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',64.4729,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server', 7.6417,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',47.3476,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',95.3656,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql', 2.8581,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',60.2241,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',70.0218,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',93.7019,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',96.6072,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',96.1564,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',40.8252,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',78.9244,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',76.0707,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',79.2523,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',17.5961,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',79.4798,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',90.6915,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',41.8566,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',86.2911,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',27.4046,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',91.4712,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',35.0394,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',49.6164,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',57.0762,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',78.2940,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',61.9455,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',47.1377,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',37.2983,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',28.2663,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',14.2189,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres', 1.1390,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2',75.8548,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',10.0044,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',11.3203,'Sef','2018-01-09');
INSERT INTO mydata VALUES ('oracle',48.2786,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',82.3469,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server', 1.2503,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',51.3264,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',67.3593,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',41.9766,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',50.0672,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',44.9801,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql', 9.8846,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',82.1426,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',35.4940,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',85.9480,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',24.1819,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',53.9155,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',92.3687,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',31.7006,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2', 2.6039,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',26.9711,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql', 5.5006,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',64.3370,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',51.2714,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',20.7777,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',58.3850,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',93.0782,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',48.2704,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',26.4547,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',14.3992,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',50.3836,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',87.6251,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',66.5472,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite',59.8254,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',22.4711,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',75.8419,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',84.1100,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2',45.0801,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',35.7495,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',64.5807,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',48.4455,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',95.5049,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',82.8685,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',14.5874,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',40.1398,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql', 1.8788,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',64.9715,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',78.8046,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',10.2080,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',68.0812,'XNF','2015-08-01');
INSERT INTO mydata VALUES ('db2', 9.8774,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',29.3878,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',10.0842,'Sef','2018-01-09');
INSERT INTO mydata VALUES ('oracle', 7.9584,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',53.0055,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server', 8.3412,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',76.3508,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',20.6714,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',22.6129,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',25.3127,'6Uy','2016-04-01');
INSERT INTO mydata VALUES ('sqlite',99.8150,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',72.5899,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',43.8807,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',33.3448,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',81.9210,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',81.5376,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',74.9513,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',82.8264,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',47.9136,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',56.6061,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',99.9673,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',40.1035,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql', 2.9264,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',67.4321,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',15.9473,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',34.1154,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',97.8247,'I4m','2015-05-02');
INSERT INTO mydata VALUES ('mysql',56.5744,'LlB','2018-06-18');
INSERT INTO mydata VALUES ('db2',65.8210,'d7I','2015-05-10');
INSERT INTO mydata VALUES ('sql server',37.9701,'4Wn','2017-01-29');
INSERT INTO mydata VALUES ('db2',62.7565,'sqz','2016-01-05');
INSERT INTO mydata VALUES ('db2',97.8724,'fS1','2018-07-24');
INSERT INTO mydata VALUES ('mysql',87.2031,'1hp','2015-11-01');
INSERT INTO mydata VALUES ('sqlite', 7.8816,'vxS','2016-02-26');
INSERT INTO mydata VALUES ('sql server',36.3160,'wB8','2015-02-16');
INSERT INTO mydata VALUES ('sql server',63.2783,'CD3','2016-06-08');
INSERT INTO mydata VALUES ('sql server',11.9677,'SXz','2015-09-29');
INSERT INTO mydata VALUES ('db2', 8.9804,'h1D','2017-04-30');
INSERT INTO mydata VALUES ('db2',32.5563,'fjD','2018-02-08');
INSERT INTO mydata VALUES ('mysql',91.1668,'Snh','2015-07-06');
INSERT INTO mydata VALUES ('mysql',44.6578,'TSs','2016-10-21');
INSERT INTO mydata VALUES ('db2',64.9643,'XT8','2018-11-17');
INSERT INTO mydata VALUES ('sqlite',66.1874,'Tea','2018-03-20');
INSERT INTO mydata VALUES ('mysql',80.2896,'yU1','2018-08-01');
INSERT INTO mydata VALUES ('mysql',23.5679,'EH5','2017-10-27');
INSERT INTO mydata VALUES ('mysql',32.5563,'BmM','2018-09-21');
INSERT INTO mydata VALUES ('mysql',88.0580,'14M','2017-04-30');
INSERT INTO mydata VALUES ('sql server',70.9191,'5RJ','2017-01-26');
INSERT INTO mydata VALUES ('db2',24.7059,'RPQ','2018-11-22');
INSERT INTO mydata VALUES ('postgres',63.7186,'XNF','2018-08-01');
INSERT INTO mydata VALUES ('db2',70.9697,'AER','2017-05-07');
INSERT INTO mydata VALUES ('db2',34.6733,'0aW','2015-03-05');
INSERT INTO mydata VALUES ('postgres',63.4341,'Sef','2016-01-09');
INSERT INTO mydata VALUES ('oracle',86.8377,'niw','2017-12-14');
INSERT INTO mydata VALUES ('db2',50.4767,'38C','2015-07-06');
INSERT INTO mydata VALUES ('sql server',74.0301,'oCx','2016-06-10');
INSERT INTO mydata VALUES ('oracle',95.5226,'jeg','2016-10-10');
INSERT INTO mydata VALUES ('mysql',86.0101,'FdZ','2018-09-15');
INSERT INTO mydata VALUES ('sqlite',17.8923,'Eqc','2016-09-22');
INSERT INTO mydata VALUES ('postgres',85.2894,'6Uy','2018-04-01');
INSERT INTO mydata VALUES ('sqlite',40.1763,'wA9','2015-03-04');
INSERT INTO mydata VALUES ('mysql',54.3718,'8db','2015-12-30');
INSERT INTO mydata VALUES ('mysql',21.2675,'Wx0','2015-02-25');
INSERT INTO mydata VALUES ('postgres',69.7758,'DC4','2017-05-26');
INSERT INTO mydata VALUES ('oracle',44.1419,'k2H','2017-03-23');
INSERT INTO mydata VALUES ('oracle',68.2549,'IYL','2017-06-13');
INSERT INTO mydata VALUES ('sql server',37.6706,'84M','2017-09-09');
INSERT INTO mydata VALUES ('db2',74.8005,'Kg1','2015-02-19');
INSERT INTO mydata VALUES ('oracle',49.8013,'jJ4','2017-12-11');
INSERT INTO mydata VALUES ('db2',69.6342,'r3R','2018-01-05');
INSERT INTO mydata VALUES ('sql server',84.8430,'5U1','2016-08-27');
INSERT INTO mydata VALUES ('mysql',67.1252,'b5I','2016-04-02');
INSERT INTO mydata VALUES ('mysql',86.8765,'aJ8','2016-09-06');
INSERT INTO mydata VALUES ('mysql',99.0954,'XBh','2015-03-12');
INSERT INTO mydata VALUES ('sqlite',95.7646,'iFF','2016-06-07');
INSERT INTO mydata VALUES ('sqlite',88.2386,'dPj','2017-04-19');
INSERT INTO mydata VALUES ('sqlite',25.2176,'I4m','2015-05-02');

WITH agg AS (
    SELECT mytype, MAX(myDate) AS MaxDate, SUM(mynum) AS SumYear
    FROM mydata
    GROUP BY mytype
),

dates AS (   
   SELECT agg.mytype, agg.MaxDate AS rec_date, agg.SumYear / 12 as SumMonth
   FROM agg
   UNION ALL
   SELECT agg.mytype, DATEADD(MONTH, 1, rec_date), agg.SumYear / 12
   FROM dates
   INNER JOIN agg
   ON agg.mytype = dates.mytype
   AND dates.rec_date <  DATEADD(MONTH, 11, agg.MaxDate)
)

SELECT * 
FROM (
  SELECT mytype, 
         DATEPART(YEAR, rec_date) AS [Year],
         DATENAME(MONTH, rec_date) AS [Month], 
         SumMonth AS TotalMonth
  FROM dates
) tbl

PIVOT
   (SUM(TotalMonth) 
    FOR [Month] IN ( [January] ,[February] ,[March] ,[April] ,
                     [May] ,[June] ,[July] ,[August] ,[September],
                     [October] ,[November] ,[December])) M
ORDER BY mytype, [Year]

View schema
Execution time: 0,16 sec, rows selected: 12, rows affected: 500, absolute service time: 0,34 sec, absolute service time: 0,35 sec