do you mean this?--SELECT * FROM RVNUTYP_EXCPTNDECLARE @Year int,@WeekNo int= 7SET @Year=2014SELECT DATEADD(dd,DATEDIFF(dd,0,DATEADD(wk,@WeekNo-1,DATEADD(yy,@Year-1900,0)))/7 * 7-1,0),DATEADD(dd,DATEDIFF(dd,0,DATEADD(wk,@WeekNo-1,DATEADD(yy,@Year-1900,0)))/7 * 7+5,0)
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs