By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| EventId | StartDate | EndDate |
|---|---|---|
| 1 | 2024-01-14 | 2024-01-14 |
| 2 | 2024-02-01 | 2024-02-02 |
| 3 | 2024-03-01 | 2024-03-03 |
| EventId | EventDate | StartDate | EndDate | Lvl |
|---|---|---|---|---|
| 1 | 2024-01-14 | 2024-01-14 | 2024-01-14 | 0 |
| 2 | 2024-02-01 | 2024-02-01 | 2024-02-02 | 0 |
| 2 | 2024-02-02 | 2024-02-01 | 2024-02-02 | 1 |
| 3 | 2024-03-01 | 2024-03-01 | 2024-03-03 | 0 |
| 3 | 2024-03-02 | 2024-03-01 | 2024-03-03 | 1 |
| 3 | 2024-03-03 | 2024-03-01 | 2024-03-03 | 2 |
1 rows affected
Msg 530 Level 16 State 1 Line 1
The statement terminated. The maximum recursion 100 has been exhausted before statement completion.
| EventId | EventDate | StartDate | EndDate | Lvl |
|---|---|---|---|---|
| 1 | 2024-01-14 | 2024-01-14 | 2024-01-14 | 0 |
| 2 | 2024-02-01 | 2024-02-01 | 2024-02-02 | 0 |
| 2 | 2024-02-02 | 2024-02-01 | 2024-02-02 | 1 |
| 3 | 2024-03-01 | 2024-03-01 | 2024-03-03 | 0 |
| 3 | 2024-03-02 | 2024-03-01 | 2024-03-03 | 1 |
| 3 | 2024-03-03 | 2024-03-01 | 2024-03-03 | 2 |
| 4 | 2024-01-01 | 2024-01-01 | 2024-04-11 | 0 |
| 4 | 2024-01-02 | 2024-01-01 | 2024-04-11 | 1 |
| 4 | 2024-01-03 | 2024-01-01 | 2024-04-11 | 2 |
| 4 | 2024-01-04 | 2024-01-01 | 2024-04-11 | 3 |
| 4 | 2024-01-05 | 2024-01-01 | 2024-04-11 | 4 |
| 4 | 2024-01-06 | 2024-01-01 | 2024-04-11 | 5 |
| 4 | 2024-01-07 | 2024-01-01 | 2024-04-11 | 6 |
| 4 | 2024-01-08 | 2024-01-01 | 2024-04-11 | 7 |
| 4 | 2024-01-09 | 2024-01-01 | 2024-04-11 | 8 |
| 4 | 2024-01-10 | 2024-01-01 | 2024-04-11 | 9 |
| 4 | 2024-01-11 | 2024-01-01 | 2024-04-11 | 10 |
| 4 | 2024-01-12 | 2024-01-01 | 2024-04-11 | 11 |
| 4 | 2024-01-13 | 2024-01-01 | 2024-04-11 | 12 |
| 4 | 2024-01-14 | 2024-01-01 | 2024-04-11 | 13 |
| 4 | 2024-01-15 | 2024-01-01 | 2024-04-11 | 14 |
| 4 | 2024-01-16 | 2024-01-01 | 2024-04-11 | 15 |
| 4 | 2024-01-17 | 2024-01-01 | 2024-04-11 | 16 |
| 4 | 2024-01-18 | 2024-01-01 | 2024-04-11 | 17 |
| 4 | 2024-01-19 | 2024-01-01 | 2024-04-11 | 18 |
| 4 | 2024-01-20 | 2024-01-01 | 2024-04-11 | 19 |
| 4 | 2024-01-21 | 2024-01-01 | 2024-04-11 | 20 |
| 4 | 2024-01-22 | 2024-01-01 | 2024-04-11 | 21 |
| 4 | 2024-01-23 | 2024-01-01 | 2024-04-11 | 22 |
| 4 | 2024-01-24 | 2024-01-01 | 2024-04-11 | 23 |
| 4 | 2024-01-25 | 2024-01-01 | 2024-04-11 | 24 |
| 4 | 2024-01-26 | 2024-01-01 | 2024-04-11 | 25 |
| 4 | 2024-01-27 | 2024-01-01 | 2024-04-11 | 26 |
| 4 | 2024-01-28 | 2024-01-01 | 2024-04-11 | 27 |
| 4 | 2024-01-29 | 2024-01-01 | 2024-04-11 | 28 |
| 4 | 2024-01-30 | 2024-01-01 | 2024-04-11 | 29 |
| 4 | 2024-01-31 | 2024-01-01 | 2024-04-11 | 30 |
| 4 | 2024-02-01 | 2024-01-01 | 2024-04-11 | 31 |
| 4 | 2024-02-02 | 2024-01-01 | 2024-04-11 | 32 |
| 4 | 2024-02-03 | 2024-01-01 | 2024-04-11 | 33 |
| 4 | 2024-02-04 | 2024-01-01 | 2024-04-11 | 34 |
| 4 | 2024-02-05 | 2024-01-01 | 2024-04-11 | 35 |
| 4 | 2024-02-06 | 2024-01-01 | 2024-04-11 | 36 |
| 4 | 2024-02-07 | 2024-01-01 | 2024-04-11 | 37 |
| 4 | 2024-02-08 | 2024-01-01 | 2024-04-11 | 38 |
| 4 | 2024-02-09 | 2024-01-01 | 2024-04-11 | 39 |
| 4 | 2024-02-10 | 2024-01-01 | 2024-04-11 | 40 |
| 4 | 2024-02-11 | 2024-01-01 | 2024-04-11 | 41 |
| 4 | 2024-02-12 | 2024-01-01 | 2024-04-11 | 42 |
| 4 | 2024-02-13 | 2024-01-01 | 2024-04-11 | 43 |
| 4 | 2024-02-14 | 2024-01-01 | 2024-04-11 | 44 |
| 4 | 2024-02-15 | 2024-01-01 | 2024-04-11 | 45 |
| 4 | 2024-02-16 | 2024-01-01 | 2024-04-11 | 46 |
| 4 | 2024-02-17 | 2024-01-01 | 2024-04-11 | 47 |
| 4 | 2024-02-18 | 2024-01-01 | 2024-04-11 | 48 |
| 4 | 2024-02-19 | 2024-01-01 | 2024-04-11 | 49 |
| 4 | 2024-02-20 | 2024-01-01 | 2024-04-11 | 50 |
| 4 | 2024-02-21 | 2024-01-01 | 2024-04-11 | 51 |
| 4 | 2024-02-22 | 2024-01-01 | 2024-04-11 | 52 |
| 4 | 2024-02-23 | 2024-01-01 | 2024-04-11 | 53 |
| 4 | 2024-02-24 | 2024-01-01 | 2024-04-11 | 54 |
| 4 | 2024-02-25 | 2024-01-01 | 2024-04-11 | 55 |
| 4 | 2024-02-26 | 2024-01-01 | 2024-04-11 | 56 |
| 4 | 2024-02-27 | 2024-01-01 | 2024-04-11 | 57 |
| 4 | 2024-02-28 | 2024-01-01 | 2024-04-11 | 58 |
| 4 | 2024-02-29 | 2024-01-01 | 2024-04-11 | 59 |
| 4 | 2024-03-01 | 2024-01-01 | 2024-04-11 | 60 |
| 4 | 2024-03-02 | 2024-01-01 | 2024-04-11 | 61 |
| 4 | 2024-03-03 | 2024-01-01 | 2024-04-11 | 62 |
| 4 | 2024-03-04 | 2024-01-01 | 2024-04-11 | 63 |
| 4 | 2024-03-05 | 2024-01-01 | 2024-04-11 | 64 |
| 4 | 2024-03-06 | 2024-01-01 | 2024-04-11 | 65 |
| 4 | 2024-03-07 | 2024-01-01 | 2024-04-11 | 66 |
| 4 | 2024-03-08 | 2024-01-01 | 2024-04-11 | 67 |
| 4 | 2024-03-09 | 2024-01-01 | 2024-04-11 | 68 |
| 4 | 2024-03-10 | 2024-01-01 | 2024-04-11 | 69 |
| 4 | 2024-03-11 | 2024-01-01 | 2024-04-11 | 70 |
| 4 | 2024-03-12 | 2024-01-01 | 2024-04-11 | 71 |
| 4 | 2024-03-13 | 2024-01-01 | 2024-04-11 | 72 |
| 4 | 2024-03-14 | 2024-01-01 | 2024-04-11 | 73 |
| 4 | 2024-03-15 | 2024-01-01 | 2024-04-11 | 74 |
| 4 | 2024-03-16 | 2024-01-01 | 2024-04-11 | 75 |
| 4 | 2024-03-17 | 2024-01-01 | 2024-04-11 | 76 |
| 4 | 2024-03-18 | 2024-01-01 | 2024-04-11 | 77 |
| 4 | 2024-03-19 | 2024-01-01 | 2024-04-11 | 78 |
| 4 | 2024-03-20 | 2024-01-01 | 2024-04-11 | 79 |
| 4 | 2024-03-21 | 2024-01-01 | 2024-04-11 | 80 |
| 4 | 2024-03-22 | 2024-01-01 | 2024-04-11 | 81 |
| 4 | 2024-03-23 | 2024-01-01 | 2024-04-11 | 82 |
| 4 | 2024-03-24 | 2024-01-01 | 2024-04-11 | 83 |
| 4 | 2024-03-25 | 2024-01-01 | 2024-04-11 | 84 |
| 4 | 2024-03-26 | 2024-01-01 | 2024-04-11 | 85 |
| 4 | 2024-03-27 | 2024-01-01 | 2024-04-11 | 86 |
| 4 | 2024-03-28 | 2024-01-01 | 2024-04-11 | 87 |
| 4 | 2024-03-29 | 2024-01-01 | 2024-04-11 | 88 |
| 4 | 2024-03-30 | 2024-01-01 | 2024-04-11 | 89 |
| 4 | 2024-03-31 | 2024-01-01 | 2024-04-11 | 90 |
| 4 | 2024-04-01 | 2024-01-01 | 2024-04-11 | 91 |
| 4 | 2024-04-02 | 2024-01-01 | 2024-04-11 | 92 |
| 4 | 2024-04-03 | 2024-01-01 | 2024-04-11 | 93 |
| 4 | 2024-04-04 | 2024-01-01 | 2024-04-11 | 94 |
| 4 | 2024-04-05 | 2024-01-01 | 2024-04-11 | 95 |
| 4 | 2024-04-06 | 2024-01-01 | 2024-04-11 | 96 |
| 4 | 2024-04-07 | 2024-01-01 | 2024-04-11 | 97 |
| 4 | 2024-04-08 | 2024-01-01 | 2024-04-11 | 98 |
| 4 | 2024-04-09 | 2024-01-01 | 2024-04-11 | 99 |
| 4 | 2024-04-10 | 2024-01-01 | 2024-04-11 | 100 |
| 4 | 2024-04-11 | 2024-01-01 | 2024-04-11 | 101 |