sql server - required back five year data .with weekno ,weekdateformat ,year, financial year -


  1. required 5 year data weekno ,weekdateformat ,year, financial year

    1. but required week no 1 financial year

      1,mar 28 2015 - apr 03 2016 ,2016-2017 ,2016

/procedure weekyearformat/

create procedure [dbo].[proc_weekyearformat] @weeknum int , @yearnum int  begin     set nocount on;     set fmtonly off ; set  @weeknum=datepart(wk,getdate()); set @yearnum=datepart(yyyy,getdate()) declare  @yearcout int =5;   select *  -- once have @weeknum , @yearnum set, following calculates date range. (select datepart(wk,dateadd(wk,-10,getdate())) count1, convert(varchar(11),dateadd(wk, datediff(wk, 6, '1/1/' + convert(char,@yearnum)) +  (@weeknum-1), 0))+' - '+   convert(varchar(11),dateadd(wk, datediff(wk, 5, '1/1/' + convert(char,@yearnum)) + (@weeknum-1), -1))   formatset,convert(varchar,@yearnum)+'-'+convert(varchar,@yearnum+1) yearset,  convert(varchar,@yearnum)  yearone ) startofweek; end   --exec proc_weekyearformat 1,2016


-