title: Getting week number off a date in MS SQL Server 2005?
body: <p>Is it possible to create an sql statement that selects the week number (NOT the day of week - or the day number in a week). I'm creating a view to select this extra information along with a couple of other fields and thus can not use a stored procedure. I'm aware that it's possible to create a UDF to do the trick, but if at all possible i'd rather only have to add a view to this database, than both a view and a function.</p>
  <p>Any ideas? Also where i come from, the week starts monday and week 1 is the first week of the year with atleast 4 days.</p>
  <h3>Related:</h3>
  <blockquote>
  <p><a href="https://stackoverflow.com/questions/274861/how-do-i-calculate-the-week-number-given-a-date">How do I calculate the week number given a date?</a></p>
  </blockquote>