Finding the week for a given date

If you have ever written code specifically just to find the date in which a date falls into, you might want to check out this interesting article,

"Best Week Ever"

The article shows you how to make use of a user-defined function to extend SQL Server to give you the correct date.

Src: "Best Week Ever"
-----------------------------------
Partial Public Class UserDefinedFunctions
_
Public Shared Function WeekInYear(ByVal dt As DateTime) As Integer
Return DatePart("ww", dt, FirstDayOfWeek.Monday, _
FirstWeekOfYear.FirstFourDays)
End Function
End Class

declare @d datetime
set @d = '13 november 2005'
select dbo.WeekInYear(@d)
-----------------------------------