title: SQL Server : group by a function on a field an select that
body: <p>I have a <code>group by YEAR(mydate),MONTH(mydate)</code></p>
  
  <p>I want to select them as a unique field like</p>
  
  <pre><code>SELECT SUM(Price),YEAR(mydate) + '/' + MONTH(mydate)
  FROM MyTable
  GROUP BY YEAR(mydate), MONTH(mydate)
  </code></pre>
  
  <p>or something like this.</p>
  
  <p><code>mydate</code> is <code>smalldatetime</code>.</p>
  
  <p>Is it possible?</p>