Calculating Union of Date Ranges
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
£
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
TestRowsLoz CTELoz CursorLoz HybridGordon CTEBummi TempTristan CTETristan CTE + TF
2
Consecutive 1hr Ranges10000000000
3
20001002401311
4
30002002422
5
40004003644
6
50007005367
7
6000100071910
8
70001300931213
9
800018001181617
10
900022002121
11
1000028002528
12
Identical 1hr Ranges10000000000
13
20001000000
14
30002000011
15
40004000033
16
50007000055
17
600010000077
18
700013000099
19
80001800001212
20
90002200001516
21
100002800001919
22
1 - 240 min ranges, 7 days1000000000
23
250000000
24
10000001000
25
200010019910
26
300020011
27
400040011
28
500070012
29
6000100023
30
7000130025
31
8000170026
32
9000220038
33
100002700310
34
1 - 240 min ranges, 365 days1000000255300
35
20001002337401
36
30002008812
37
400040010424
38
500070011646
39
60001000129168
40
700013001412010
41
8000170015112
42
9000220016115
43
10000270017118
44
1000002815021065
45
1000000717
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
Test 1
Test 2
Test 3
Test 4