try a recursive CTE approach;With YourCTENameAS(SELECT WeekNumber,Var1,Var1 AS carry_over_effect_0.2FROM TableWHERE WeekNumber=1UNION ALLSELECT t.WeekNumber,t.Var1,t.Var1 + 0.2 * c.carry_over_effect_0.2FROM Table tJOIN YourCTEName cON c.WeekNumber = t.WeekNumber -1)SELECT *FROM YourCTENAmeOPTION (MAXRECURSION 0)
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs