Stackoverflow - 30 day moving sum using the OVER clause in SQL server ..., Sql Server

Stackoverflow - 30 day moving sum using the OVER clause in SQL server ...

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 7, rows affected: 7, absolute service time: 0,17 sec

fork mode | history

  
CustNo
TransactionDate
TransactionAmount
MovingAmount

1
1111
07.05.2015 00:00:00
3000
12000

2
1111
14.05.2015 00:00:00
3000
12000

3
1111
21.05.2015 00:00:00
3000
9000

4
1111
28.05.2015 00:00:00
3000
6000

5
1111
10.06.2015 00:00:00
3000
3000

6
2222
17.05.2015 00:00:00
100
100

7
3333
31.05.2015 00:00:00
11000
11000

λ

                                      .NET NoSQL database for rapid development