Invoice Total Year Month Pivot Query, Sql Server

Language: Layout:

IF OBJECT_ID('dbo.Invoice', 'U') IS NOT NULL 
  DROP TABLE dbo.Invoice; 
  
CREATE TABLE [Invoice] (

InvoiceTotal DECIMAL,
    CreatedUtc DATETIME
    
);

INSERT INTO Invoice ([InvoiceTotal], [CreatedUtc])
SELECT 8.4836677073, '2013-04-07 04:16:51' UNION
SELECT 15.50129424, '2013-01-31 05:58:41' UNION
SELECT 13.19407022, '2013-05-03 11:20:09' UNION
SELECT 150.84409087, '2013-06-17 21:18:39' UNION
SELECT 88.844559914, '2013-12-28 00:08:07' UNION
SELECT 24.67002045, '2013-02-19 21:00:20' UNION
SELECT 159.38267951, '2013-04-23 17:59:40' UNION
SELECT 115.10818473, '2013-01-21 04:49:52' UNION
SELECT 181.9070661, '2014-04-29 09:15:03' UNION
SELECT 160.98981352, '2014-10-26 01:30:09' UNION
SELECT 58.7794361, '2014-07-26 19:03:54' UNION
SELECT 46.754678219, '2014-11-22 17:40:55' UNION
SELECT 45.616936334, '2014-04-30 23:29:35' UNION
SELECT 65.556719206, '2014-07-01 23:24:42' UNION
SELECT 152.6531747, '2014-04-08 22:28:03' UNION
SELECT 4.6536209076, '2014-02-07 02:52:38' UNION
SELECT 66.68334026, '2014-12-09 08:27:34' UNION
SELECT 69.81648766, '2014-08-03 03:30:12' UNION
SELECT 12.351168182, '2014-01-29 11:55:44' UNION
SELECT 37.16494256, '2014-03-20 15:02:35';

SELECT * FROM [Invoice];

SELECT * FROM (
  SELECT
    YEAR(CreatedUtc) AS [Year],    
    DATENAME(MONTH, CreatedUtc) AS [Month Name],
    SUM(InvoiceTotal) as [InvoiceTotal]
  FROM [dbo].[Invoice]
  GROUP BY YEAR(CreatedUtc), DATENAME(MONTH,CreatedUtc)
) AS t

PIVOT (
  SUM(InvoiceTotal) 
  FOR [Month Name] IN ([January],[February],[March],[April],[May],
    [June],[July],[August],[September],[October],[November],
    [December])) AS MNamePivot
ORDER BY 1,2

View schema
Execution time: 0,02 sec, rows selected: 22, rows affected: 20, absolute service time: 0,17 sec