Partition Function COUNT() OVER possible using DISTINCT, Sql Server

Partition Function COUNT() OVER possible using DISTINCT

Language: Layout:

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

fork mode | history

  
datekey
RunningTotal
RunningCount
RunningDistinctCount

1
20120101
1
1
1

2
20120102
2
2
2

3
20120103
3
3
3

4
20120104
9
6
4

5
20120104
9
6
4

6
20120104
9
6
4

7
20120105
10
7
5

8
20120106
11
8
6

9
20120107
13
10
7

10
20120107
13
10
7

11
20120108
16
12
8

12
20120108
16
12
8

13
20120109
17
13
9

14
20120110
18
14
10


  
datekey
RunningTotal

1
20120101
1

2
20120102
2

3
20120103
3

4
20120104
9

5
20120104
9

6
20120104
9

7
20120105
10

8
20120106
11

9
20120107
13

10
20120107
13

11
20120108
16

12
20120108
16

13
20120109
17

14
20120110
18

λ

                                      .NET NoSQL database for rapid development