Hi,
I need a view with weeknumbers according to ISO. This means 1-1-2006 is week 53.
Now I created a function:
[MS SQL] CREATE FUNCTION dbo.WOY
( @Date DATETIME )
RETURNS SMALLINT
AS
BEGIN
DECLARE @WEEK SMALLINT
IF DATEPART(dw, CAST('1-1-' + CAST(DATEPART(YYYY, @Date) AS VARCHAR) AS DATETIME)) > 4
IF DATEPART(ww, @Date) = 1
SET @WEEK = 53
ELSE SET @WEEK = DATEPART(ww, @Date) -1
ELSE SET @WEEK = DATEPART(ww, @Date)
RETURN ( @WEEK )
END[/MS SQL]
In a view I added a column WOY(Date)
Now I need somehow set the datefirst to 1 but how can I do that?
Anyone?