Cases Logged Per Month - 2004 true SELECT DISTINCT MONTH(CAST(CONVERT(nvarchar(10), DateEntered, 112) AS datetime)) AS TheMonth, CASE MONTH(CAST(CONVERT(nvarchar(10), DateEntered, 112) AS datetime)) WHEN 1 THEN 'JAN' WHEN 2 THEN 'FEB' WHEN 3 THEN 'MAR' WHEN 4 THEN 'APR' WHEN 5 THEN 'MAY' WHEN 6 THEN 'JUN' WHEN 7 THEN 'JUL' WHEN 8 THEN 'AUG' WHEN 9 THEN 'SEP' WHEN 10 THEN 'OCT' WHEN 11 THEN 'NOV' WHEN 12 THEN 'DEC' END MONTHNAME, COUNT(CallID) AS TheCount FROM tbl_Calls WHERE (DateEntered BETWEEN CONVERT(DATETIME, '2004-01-01', 102) AND CONVERT(DATETIME, '2004-12-31', 102)) GROUP BY MONTH(CAST(CONVERT(nvarchar(10), DateEntered, 112) AS datetime)) ORDER BY MONTH(CAST(CONVERT(nvarchar(10), DateEntered, 112) AS datetime)) Month Number of Cases Logged