title: Week() function in sql script
body: <p>I am using sql server 2005. I just want to know is there something we can get the week number for the particular month. Example <code>Date = '2008-10-16'</code> Is there something we can have <code>SELECT WEEK(Date)</code>. Or any better suggestion.</p>