DateCustomSort, Sql Server

Language: Layout:

CREATE TABLE Entry(ID INT, EntryName NVARCHAR(100), Entries INT,  DateOfEntry DATE)

INSERT INTO Entry VALUES(1, 'A', 20,'1/17/2016')
INSERT INTO Entry VALUES(2, 'B', 22,'1/29/2016')
INSERT INTO Entry VALUES(3, 'C', 23,'2/17/2016')
INSERT INTO Entry VALUES(4, 'D', 19,'2/17/2016')
INSERT INTO Entry VALUES(5, 'E', 29,'3/17/2016')
INSERT INTO Entry VALUES(6, 'F', 30,'3/17/2016')
INSERT INTO Entry VALUES(7, 'G', 43,'4/17/2016')
INSERT INTO Entry VALUES(8, 'H', 10,'4/17/2016')
INSERT INTO Entry VALUES(9, 'I', 5,'5/17/2016')
INSERT INTO Entry VALUES(10, 'J', 120,'5/17/2016')
INSERT INTO Entry VALUES(11, 'K', 220,'6/17/2016')
INSERT INTO Entry VALUES(12, 'L', 210,'6/17/2016')
INSERT INTO Entry VALUES(13, 'M', 10,'7/17/2016')
INSERT INTO Entry VALUES(14, 'N', 20,'7/17/2016')
INSERT INTO Entry VALUES(15, 'O', 15,'8/17/2016')
INSERT INTO Entry VALUES(16, 'P', 17,'8/17/2016')
INSERT INTO Entry VALUES(17, 'Q', 19,'9/17/2016')
INSERT INTO Entry VALUES(18, 'R', 23,'9/17/2016')
INSERT INTO Entry VALUES(19, 'S', 43,'10/17/2016')
INSERT INTO Entry VALUES(20, 'T', 56,'10/17/2016')
INSERT INTO Entry VALUES(21, 'U', 65,'11/17/2016')
INSERT INTO Entry VALUES(22, 'V', 78,'11/17/2016')
INSERT INTO Entry VALUES(23, 'W', 12,'12/17/2016')
INSERT INTO Entry VALUES(24, 'X', 23,'12/17/2016')
INSERT INTO Entry VALUES(25, 'Y', 43,'2/17/2016')
INSERT INTO Entry VALUES(26, 'Z', 67,'3/17/2016')

INSERT INTO Entry VALUES(27, 'AA', 35,'1/17/2015')
INSERT INTO Entry VALUES(28, 'AB', 23,'1/29/2015')
INSERT INTO Entry VALUES(29, 'AC', 43,'2/17/2015')
INSERT INTO Entry VALUES(30, 'AD', 35,'2/17/2015')
INSERT INTO Entry VALUES(31, 'AE', 45,'3/17/2015')
INSERT INTO Entry VALUES(32, 'AF', 23,'3/17/2015')
INSERT INTO Entry VALUES(33, 'AG', 43,'4/17/2015')
INSERT INTO Entry VALUES(34, 'AH', 19,'4/17/2015')
INSERT INTO Entry VALUES(35, 'AI', 21,'5/17/2015')
INSERT INTO Entry VALUES(36, 'AJ', 13,'5/17/2015')
INSERT INTO Entry VALUES(37, 'AK', 22,'6/17/2015')
INSERT INTO Entry VALUES(38, 'AL', 45,'6/17/2015')
INSERT INTO Entry VALUES(39, 'AM', 66,'7/17/2015')
INSERT INTO Entry VALUES(40, 'AN', 77,'7/17/2015')
INSERT INTO Entry VALUES(41, 'AO', 89,'8/17/2015')
INSERT INTO Entry VALUES(42, 'AP', 127,'8/17/2015')
INSERT INTO Entry VALUES(43, 'AQ', 19,'9/17/2015')
INSERT INTO Entry VALUES(44, 'AR', 223,'9/17/2015')
INSERT INTO Entry VALUES(45, 'AS', 143,'10/17/2015')
INSERT INTO Entry VALUES(46, 'AT', 36,'10/17/2015')
INSERT INTO Entry VALUES(47, 'AU', 45,'11/17/2015')
INSERT INTO Entry VALUES(48, 'AV', 28,'11/17/2015')
INSERT INTO Entry VALUES(49, 'AW', 72,'12/17/2015')
INSERT INTO Entry VALUES(50, 'AX', 24,'12/17/2015')
INSERT INTO Entry VALUES(51, 'AY', 46,'2/17/2015')
INSERT INTO Entry VALUES(52, 'AZ', 62,'3/17/2015')

DECLARE    @StartDate DATE
SET        @StartDate  = '2/1/2015'

SELECT		sortingList.MonthOfEntry,
			sortingList.TotalEntries,
			sortingList.MonthNumber
FROM		(
			  SELECT			DateName(MONTH, DATEADD(MONTH, MONTH(e.DateOfEntry), 0) - 1) + ' ' + CONVERT(nvarchar(20),YEAR(e.DateOfEntry)) AS MonthOfEntry,
			    				SUM(e.Entries) as TotalEntries,
			    				CASE
			    					WHEN	((MONTH(e.DateOfEntry) - MONTH(@StartDate)) > 0)
			    					THEN	(MONTH(e.DateOfEntry) - MONTH(@StartDate)) + 1
									WHEN	((MONTH(e.DateOfEntry) - MONTH(@StartDate)) = 0)
									THEN	1
			    					ELSE 
			    							((12 - MONTH(@StartDate)) + (MONTH(e.DateOfEntry))) + 1
			    				END
			    				AS MonthNumber
			  FROM				Entry e
			  WHERE				e.DateOfEntry >= @StartDate AND e.DateOfEntry < DATEADD(YEAR, 1, @StartDate)
			  GROUP BY			DateName(MONTH, DATEADD(MONTH, MONTH(e.DateOfEntry), 0) - 1), YEAR(e.DateOfEntry), MONTH(e.DateOfEntry) - MONTH(@StartDate), MONTH(e.DateOfEntry)
			) sortingList
ORDER BY	sortingList.MonthNumber ASC

View schema
Execution time: 0,05 sec, rows selected: 13, rows affected: 52, absolute service time: 0,2 sec