title: Get week number of month SQL Server
body: <p>I am trying to find the week number of a particular month given a date, so I want to know which week is that for given month </p>
  
  <p>Example if I enter  </p>
  
  <ul>
  <li>2016 Feb 2 ---> Week 1</li>
  <li>2016 Feb 9 ---> Week 2</li>
  <li>2016 June 2 ---> week 1</li>
  <li>2016 Jan 25 ---> week 5</li>
  </ul>
  
  <p>Can I achieve this in a T-SQL query?</p>
  
  <p>I have seen the following option </p>
  
  <pre><code>DATEPART(wk, BookingTimeStamp)
  </code></pre>
  
  <p>But that gives the week number of the year, not the month </p>
  
  <p>The idea is to build result per week for a given month</p>