Sum(R) {R = 1..N} = N * (N + 1) / 2

SELECT T.N, T.N * (T.N + 1) / 2 AS SumOfN
FROM Tally T
WHERE (T.N BETWEEN 1 AND 10)

N           SumOfN      
----------- ----------- 
1           1
2           3
3           6
4           10
5           15
6           21
7           28
8           36
9           45
10          55

SELECT column1, column1 * (column1 + 1) / 2 AS SumOfN
FROM MyTable