Get week number of month SQL Server
<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>