My Rational Rights

RegisterStartupScript and RegisterClientScriptBlock http://chiragrdarji.blogspot.com/2008/07/registerstartupscript-and.html

alter PROC snproc_am_ytd_scoreboard_cp AS BEGIN DECLARE @no_of_days int SET @no_of_days = 24 DECLARE @yi int, @yj int,@mi int,@mj int,@month int,@noofyrs int DECLARE @yrstdate datetime, @yrenddate datetime,@monthstdate datetime, @monthenddate datetime,@CurrentDate datetime SET @month=datepart(mm,getdate()) ;set @noofyrs=-4; set @CurrentDate=getdate();--dateadd(mm,-4,getdate()); SET @yi=0; WHILE(@yi>@noofyrs) -- TO GET LAST FOUR YEARS BEGIN SELECT @yrstdate= '01/'+convert(varchar(10),'01')+'/'+convert(varchar(10),datepart(yyyy,dateadd(yyyy,@yi,@CurrentDate))); IF(@yi=0) SET @yrenddate=dateadd(dd,-1,dateadd(mm,1,convert(varchar(10),datepart(mm,@CurrentDate))+'/01/'+convert(varchar(10),datepart(yyyy,dateadd(yyyy,@yi,@CurrentDate))))); ELSE SET @yrenddate=dateadd(dd,-1,dateadd(yyyy,1,@yrstdate)); SET @yrstdate = dateadd(s,0,dateadd(mi,0,dateadd(hh,0,convert(varchar(10),@yr...