title: Isoweek in SQL Server 2005
body: <p>In SQL Server 2008 the isoweek can be found with this:</p>
  
  <pre><code>SELECT datepart(iso_week, getdate())
  </code></pre>
  
  <p>Before SQL Server 2008 there were no built-in function to find isoweek.</p>
  
  <p>I have been searching high and low for a good syntax to find a userdefined iso_week for SQL Server  2005. I found quite a few solutions. Didn't like any of the solutions I found, most of them didn't work, and they were way too long.</p>
  
  <p>Since the issue is very old, I would expect this issue is depleted and the best solution has been found. I was unable to find a good method though.</p>
  
  <p>I wrote a solution, which I am going to post later. But before I do, I want to make absolutely sure that no one else can match the solution I wrote.</p>
  
  <p>I am hoping to earn the self-learner badge. I urge people to find the best answers out there for this ancient question.</p>
  
  <p>I am going to post my answer after giving people a chance of finding a good solution.</p>