running sum calc, Sql Server

running sum calc

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 8, rows affected: 8, absolute service time: 0,19 sec

fork mode | history

  
rno
ccp
col1
col2
col3
res

1
1
ccp1
15
10
1100
1083,500000

2
2
ccp1
20
10
1210
1169,850000

3
3
ccp1
30
10
1331
1253,835000

4
4
ccp1
40
10
2000
1871,118500

5
5
ccp2
10
15
900
888,500000

6
6
ccp2
15
15
1000
969,525000

7
7
ccp2
20
15
1010
951,953750

8
8
ccp3
20
15
1010
987,000000

λ

                                      .NET NoSQL database for rapid development