title: SQL WEEK NUMBER
body: <p>I am looking for a way to extract a week number based on this calendar:
  <a href="http://www.timeanddate.com/calendar/custom.html?year=2014&amp;country=1&amp;wno=1&amp;holm=1&amp;df=1" rel="nofollow">http://www.timeanddate.com/calendar/custom.html?year=2014&amp;country=1&amp;wno=1&amp;holm=1&amp;df=1</a> </p>
  
  <p>so eg a date of '2014-12-28 00:00:00.000' should give me week 1 and not 53
  SELECT DATEPART (wk,'2014-12-28 00:00:00.000') gives 53</p>
  
  <p>please note that this is not always the same as ISO WEEK</p>
  
  <p>any idea?</p>
  
  <p>Kris</p>