title: Order by Week Descending based on current week
body: <p>Is there way to order this query by week # but starting with the current week then descending order ? So if the current week # was 2 it would order by 2,1,52,51 etc... </p>
  
  <pre><code>SELECT 
      SalesPerson
    , CAST(SUM(hours) AS DECIMAL(18 , 2))
    , DATEPART(wk , DATEADD(wk , DATEDIFF(wk , 0 , OrderDate) , 0)) AS Wk#
      FROM Orders
      WHERE OrderDate &gt;= DATEADD(month , -12 , GETDATE())
      GROUP BY DATEADD(wk , DATEDIFF(wk , 0 , OrderDate) , 0)
  </code></pre>
  
  <p>Thanks!
  E</p>