By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Stop_Date_Time | MonitorID | SpanRef |
---|---|---|
2021-03-23 15:00:00.000 | 1 | 20.00 |
2021-03-24 15:00:00.000 | 1 | 20.00 |
2021-03-25 15:00:00.000 | 1 | 40.00 |
2021-03-26 15:00:00.000 | 1 | 40.00 |
2021-03-23 15:00:00.000 | 2 | 20.00 |
2021-03-24 15:00:00.000 | 2 | 20.00 |
2021-03-25 15:00:00.000 | 2 | 40.00 |
2021-03-26 15:00:00.000 | 2 | 40.00 |
2021-03-23 15:00:00.000 | 3 | 20.00 |
2021-03-24 15:00:00.000 | 3 | 20.00 |
2021-03-25 15:00:00.000 | 3 | 40.00 |
2021-03-26 15:00:00.000 | 3 | 40.00 |
2025-03-22 13:00:00.000 | 1 | 7777.00 |
2025-03-23 08:00:00.000 | 1 | 9999.00 |
2025-03-24 17:00:00.000 | 1 | 1111.00 |
Date_Time | MonitorID | Value |
---|---|---|
2021-03-23 16:00:00.000 | 1 | 30.00 |
2021-03-26 17:00:00.000 | 1 | 50.00 |
2021-03-23 16:00:00.000 | 2 | 30.00 |
2021-03-26 17:00:00.000 | 2 | 50.00 |
2021-03-23 16:00:00.000 | 3 | 30.00 |
2021-03-26 17:00:00.000 | 3 | 50.00 |
2025-03-22 16:00:00.000 | 1 | 4444.00 |
2025-03-23 10:00:00.000 | 1 | 3333.00 |
2025-03-24 15:00:00.000 | 1 | 5555.00 |
2025-03-24 18:00:00.000 | 1 | 9999.00 |
Date_Time | MonitorID | Value | Stop_Date_Time | SpanRef |
---|---|---|---|---|
2021-03-23 16:00:00.000 | 1 | 30.00 | 2021-03-23 15:00:00.000 | 20.00 |
2021-03-23 16:00:00.000 | 2 | 30.00 | 2021-03-23 15:00:00.000 | 20.00 |
2021-03-23 16:00:00.000 | 3 | 30.00 | 2021-03-23 15:00:00.000 | 20.00 |
2021-03-26 17:00:00.000 | 1 | 50.00 | 2021-03-26 15:00:00.000 | 40.00 |
2021-03-26 17:00:00.000 | 2 | 50.00 | 2021-03-26 15:00:00.000 | 40.00 |
2021-03-26 17:00:00.000 | 3 | 50.00 | 2021-03-26 15:00:00.000 | 40.00 |
2025-03-22 16:00:00.000 | 1 | 4444.00 | 2025-03-22 13:00:00.000 | 7777.00 |
2025-03-23 10:00:00.000 | 1 | 3333.00 | 2025-03-23 08:00:00.000 | 9999.00 |
2025-03-24 15:00:00.000 | 1 | 5555.00 | 2025-03-23 08:00:00.000 | 9999.00 |
2025-03-24 18:00:00.000 | 1 | 9999.00 | 2025-03-24 17:00:00.000 | 1111.00 |