Setup:DECLARE @t TABLE(seq INT NOT NULL, Denominator FLOAT NOT NULL, IIntegral FLOAT NOT NULL)
INSERT @t SELECT
19,0.95,2684.21052631579 UNION ALL SELECT
18,0.9,3726.66666666667 UNION ALL SELECT
17,0.85,240 UNION ALL SELECT
16,0.8,3933.75 UNION ALL SELECT
15,0.75,1373.33333333333 UNION ALL SELECT
14,0.7,2524.28571428571 UNION ALL SELECT
13,0.65,3872.30769230769 UNION ALL SELECT
12,0.6,713.333333333333 UNION ALL SELECT
11,0.55,2027.27272727273 UNION ALL SELECT
10,0.5,1134 UNION ALL SELECT
9,0.45,6668.88888888889 UNION ALL SELECT
8,0.4,2287.5 UNION ALL SELECT
7,0.35,10722.8571428571 UNION ALL SELECT
6,0.3,1153.33333333333 UNION ALL SELECT
5,0.25,2840 UNION ALL SELECT
4,0.2,2540 UNION ALL SELECT
3,0.15,200 UNION ALL SELECT
2,0.1,2970 UNION ALL SELECT
1,0.05,69640
Query:SELECT SUM(b.IIntegral) integral
FROM @t a CROSS JOIN @t b
WHERE a.seq<=b.seq
GROUP BY a.seq
ORDER BY a.seq DESC
SQL 2012 version:SELECT SUM(IIntegral) OVER (ORDER BY seq DESC ROWS BETWEEN unbounded preceding AND CURRENT ROW) Integral FROM @t