title: Sql Server, Get all Week numbers by a given Year?
body: <p>is there a way to get all the week numbers by a given year?</p>
  
  <p>Let's say I have the year 2011 and want all the weeks for that year, is this possible?</p>
  
  <p>I am using Sql Server 2008.</p>