SQL Server provides the ability to find the week of the year in which a given date lies. For example: declare @d datetime set @d = '13 november 2005' select datepart(ww, @d) The result of this is 47. Now, the problem with this is that the correct result
