Ajiths blog

               I have seen several times some people use loops, cursors to do cumulative calculations. But I think we can use following basic way to do calculations without using loops or cursors .Just create sample table (run attached script) and try following SQL

DECLARE @tempValue FLOAT

SET @tempValue=1

UPDATE Sample SET @tempValue=CalculatedValue=(MonthlyValue+1)*@tempValue

SELECT * FROM Sample