Get all week number by given year using SQL Server
DECLARE @Year char(4), @iValue TINYINT, @Month tinyint --//Populate your parameter values SET @Year = '2018'; SELECT DATEPART(wk,DATEADD(wk,t2.number,@Year)) as Weeknumb,( SELECT DATENAME(month, DATEADD(month, month(DATEADD(wk,t2.number,@Year + '/01/01')), -1 ))) AS Month FROM master..spt_values t2 WHERE t2.type = 'P' AND t2.number <= 255 AND YEAR(DATEADD(wk,t2.number,@Year))=@Year
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.