Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.80K
1 Posted Topic
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 …
The End.