title: SQL Group by Week Date
body: <p>I am trying to group a list of orders in SQL Server by week date.  Using the SQL below i get the following results:</p>
  
  <pre><code>SELECT cast(datepart(wk, created) [week], count(1) [number of orders]
  FROM Orders
  GROUP BY datepart(wk, created)
  
  Week - Number of Orders
  15   - 305
  16   - 285
  17   - 428
  </code></pre>
  
  <p>What i want to do is instead of showing the Week number i want to show the week start date e.g.</p>
  
  <pre><code>Week -       Number of Orders
  11/04/2016   - 305
  18/04/2016   - 285
  25/04/2016   - 428
  </code></pre>
  
  <p>Any ideas?</p>