title: how to get week number for a date based on month from the date in sql server
body: <p>I have a date column in a table and I want to get week number for that particular date based on the month from that date irrespective of the day</p>
  
  <p>For example:</p>
  
  <pre><code>01-dec-2012 to 07-dec-2012 should give week number as 1
  08-dec-2012 to 14-dec-2012 should give week number as 2
  15-dec-2012 to 21-dec-2012 should give week number as 3
  22-dec-2012 to 28-dec-2012 should give week number as 4
  29-dec-2012 to 31-dec-2012 should give week number as 5
  </code></pre>
  
  <p>This week number is not dependent on the starting day of the week i.e, it can be any day</p>
  
  <p>How can I write a <code>select</code> statement to get this output in SQL Server 2008?</p>