title: GROUP BY Month, Display Month Name in SELECT List
body: <p>I am trying to group by month to separate my result set into monthly breakdowns, but I want to display the month name instead of the month number.</p>
  
  <pre><code>SELECT  
      DATEPART(MONTH, R.received_date) AS [Month],
      --DATENAME( MONTH, DATEPART( MONTH, R.received_date)) AS [Month] ,
      o.name AS [CountyName] ,
      rsc.description AS [Filing],
      COUNT(*) AS [Total] 
  FROM    dbo.requests AS [r]
      INNER JOIN dbo.organizations AS [o] ON o.id = r.submitted_to_organiztion_id
      INNER JOIN dbo.request_status_codes AS [rsc] ON rsc.code = r.request_status_code
  WHERE   r.submitted_to_organiztion_id &lt; 68
      AND r.request_type_code = 1
      AND CAST(r.received_date AS DATE) &gt;= '01/01/2016'
      AND CAST(r.received_date AS DATE) &lt;= '06/30/2016'
      AND o.name = 'Alachua'
  GROUP BY
      DATEPART(MONTH, R.received_date) ,
      --DATENAME( MONTH, DATEPART( MONTH, R.received_date)) ,
      o.name ,
      rsc.description;
  </code></pre>
  
  <p>And the results are expected below:</p>
  
  <p><a href="https://i.stack.imgur.com/Stpnp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Stpnp.png" alt="GROUP BY Month"></a></p>
  
  <p>But if I group by <code>DATENAME</code>, the results are not what I would expect from the query below:</p>
  
  <pre><code>SELECT  
      --DATEPART(MONTH, R.received_date) AS [Month],
      DATENAME( MONTH, DATEPART( MONTH, R.received_date)) AS [Month] ,
      o.name AS [CountyName] ,
      rsc.description AS [Filing],
      COUNT(*) AS [Total] 
  FROM    dbo.requests AS [r]
      INNER JOIN dbo.organizations AS [o] ON o.id = r.submitted_to_organiztion_id
      INNER JOIN dbo.request_status_codes AS [rsc] ON rsc.code = r.request_status_code
  WHERE   r.submitted_to_organiztion_id &lt; 68
      AND r.request_type_code = 1
      AND CAST(r.received_date AS DATE) &gt;= '01/01/2016'
      AND CAST(r.received_date AS DATE) &lt;= '06/30/2016'
      AND o.name = 'Alachua'
  GROUP BY
      --DATEPART(MONTH, R.received_date) ,
      DATENAME( MONTH, DATEPART( MONTH, R.received_date)) ,
      o.name ,
      rsc.description
  ORDER BY
      [Month] ,
      CountyName ,
      Filing
  </code></pre>
  
  <p>when 6 months become grouped into one set - January:</p>
  
  <p><a href="https://i.stack.imgur.com/gr9fb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gr9fb.png" alt="Wrong GROUPING"></a></p>
  
  <p>What can I do to fix the query to display the first result set but with the month name instead of numeric value?</p>
  
  <p>Thanks,</p>