title: Calculate the week number based on the specific start and end months, not the default SQL Server start month
body: <p>In SQL Server as we know, it calculates the week number based on the Jan 1st of the current year till Dec 31st of the current year.</p>
  
  <p>Now what I want is, I want to change these Jan 1st and Dec 31 to Mar 1 and Nov 30. Based on these SQL Server should calculate the week number.</p>
  
  <p>So could anybody give me the SQL script for this?</p>