SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE DryerHopperWeightTotal (
	TotalWeight NUMERIC(10,1),
    DateTm DATETIME
)
INSERT DryerHopperWeightTotal
VALUES
    (2420.0, '2024-02-14 06:29:06'),
    (5380.0, '2024-02-14 06:34:06'),
    (4610.0, '2024-02-14 06:39:06'),
    (1770.0, '2024-02-14 06:44:06'),
    (4710.0, '2024-02-14 06:49:06'),
    (4450.0, '2024-02-14 06:54:06'),
    (4540.0, '2024-02-14 06:59:06'),
    (4760.0, '2024-02-14 07:04:06'),
    (4870.0, '2024-02-14 07:09:07'),
    (4560.0, '2024-02-14 07:14:07'),
    (5380.0, '2024-02-14 07:19:07'),
    (4080.0, '2024-02-14 07:24:07'),
    (3090.0, '2024-02-14 07:29:07'),
    (4440.0, '2024-02-14 07:34:07'),
    (4230.0, '2024-02-14 07:39:07'),
    (4140.0, '2024-02-14 07:44:08'),
    (4490.0, '2024-02-14 07:49:08'),
    (4160.0, '2024-02-14 07:54:08'),
    (4490.0, '2024-02-14 07:59:08'),
    (4420.0, '2024-02-14 08:04:08'),
    (4450.0, '2024-02-14 08:09:08'),
    (4640.0, '2024-02-14 08:14:08'),
    (5660.0, '2024-02-14 08:19:08'),
    (4770.0, '2024-02-14 08:24:09'),
    (4760.0, '2024-02-14 08:29:09'),
    (4440.0, '2024-02-14 08:34:09'),
    (4320.0, '2024-02-14 08:39:09'),
    (1180.0, '2024-02-14 08:44:09'),
    (4410.0, '2024-02-14 08:49:09'),
    (4190.0, '2024-02-14 08:54:09'),
    (4310.0, '2024-02-14 08:59:10'),
    (5080.0, '2024-02-14 09:04:10'),
    (5270.0, '2024-02-14 09:09:10'),
    (2420.0, '2024-02-14 09:14:10'),
    (4420.0, '2024-02-14 09:19:10'),
    (4530.0, '2024-02-14 09:24:10'),
    (4600.0, '2024-02-14 09:29:10'),
    (4790.0, '2024-02-14 09:34:11'),
    (4500.0, '2024-02-14 09:39:11'),
    (4270.0, '2024-02-14 09:44:11'),
    (4550.0, '2024-02-14 09:49:11'),
    (4510.0, '2024-02-14 09:54:11'),
    (4710.0, '2024-02-14 09:59:11'),
    (4590.0, '2024-02-14 10:04:11'),
    (4740.0, '2024-02-14 10:09:11'),
    (4770.0, '2024-02-14 10:14:12'),
    (4300.0, '2024-02-14 10:19:12'),
    (5730.0, '2024-02-14 10:24:12'),
    (4950.0, '2024-02-14 10:29:12'),
    (4350.0, '2024-02-14 10:34:12'),
    (4010.0, '2024-02-14 10:39:12'),
    (1450.0, '2024-02-14 10:44:12'),
    (4440.0, '2024-02-14 10:49:12'),
    (4350.0, '2024-02-14 10:54:13'),
    (3930.0, '2024-02-14 10:59:13'),
    (3140.0, '2024-02-14 11:04:13'),
    (2540.0, '2024-02-14 11:09:13'),
    (2760.0, '2024-02-14 11:14:13'),
    (4480.0, '2024-02-14 11:19:13'),
    (4720.0, '2024-02-14 11:24:13'),
    (4890.0, '2024-02-14 11:29:14'),
    (4650.0, '2024-02-14 11:34:14'),
    (3320.0, '2024-02-14 11:39:14'),
    (1790.0, '2024-02-14 11:44:14'),
    (3620.0, '2024-02-14 11:49:14'),
    (4600.0, '2024-02-14 11:54:14'),
    (4460.0, '2024-02-14 11:59:14'),
    (3210.0, '2024-02-14 12:04:14'),
    (4470.0, '2024-02-14 12:09:16'),
    (4570.0, '2024-02-14 12:14:16'),
    (4390.0, '2024-02-14 12:19:16'),
    (4480.0, '2024-02-14 12:24:17'),
    (4590.0, '2024-02-14 12:29:17'),
    (4350.0, '2024-02-14 12:34:17'),
    (4450.0, '2024-02-14 12:39:17'),
    (1640.0, '2024-02-14 12:44:17'),
    (1090.0, '2024-02-14 12:49:17'),
    (5080.0, '2024-02-14 12:54:17'),
    (4660.0, '2024-02-14 12:59:17'),
    (3950.0, '2024-02-14 13:04:17'),
    (3740.0, '2024-02-14 13:09:18'),
    (3810.0, '2024-02-14 13:14:18'),
    (4000.0, '2024-02-14 13:19:18'),
    (4380.0, '2024-02-14 13:24:18'),
    (4230.0, '2024-02-14 13:29:18'),
    (4000.0, '2024-02-14 13:34:18'),
    (4270.0, '2024-02-14 13:39:18'),
    (4100.0, '2024-02-14 13:44:18'),
    (4360.0, '2024-02-14 13:49:19'),
    (4600.0, '2024-02-14 13:54:19'),
    (5550.0, '2024-02-14 13:59:19'),
    (   0.0, '2024-02-14 14:04:19'),
    (   0.0, '2024-02-14 14:09:19'),
    (   0.0, '2024-02-14 14:14:19'),
    (   0.0, '2024-02-14 14:19:19'),
    (3100.0, '2024-02-14 14:24:19'),
    (3890.0, '2024-02-14 14:29:19'),
    (  70.0, '2024-02-14 14:34:20'),
    (   0.0, '2024-02-14 14:39:20'),
    (   0.0, '2024-02-14 14:44:20'),
    (   0.0, '2024-02-14 14:49:20'),
    (   0.0, '2024-02-14 14:54:20'),
    (  20.0, '2024-02-14 14:59:20'),
    (3980.0, '2024-02-14 15:04:20'),
    (3170.0, '2024-02-14 15:09:20'),
    (   0.0, '2024-02-14 15:14:21'),
    (   0.0, '2024-02-14 15:19:21'),
    (   0.0, '2024-02-14 15:24:21'),
    (   0.0, '2024-02-14 15:29:21'),
    (2560.0, '2024-02-14 15:34:21'),
    (3460.0, '2024-02-14 15:39:21'),
    (2600.0, '2024-02-14 15:44:21'),
    (3920.0, '2024-02-14 15:49:21'),
    (4080.0, '2024-02-14 15:54:22'),
    (4590.0, '2024-02-14 15:59:22'),
    (4080.0, '2024-02-14 16:04:22'),
    (3820.0, '2024-02-14 16:09:23'),
    (3620.0, '2024-02-14 16:14:23'),
    (5100.0, '2024-02-14 16:19:23'),
    (5980.0, '2024-02-14 16:24:23'),
    (3960.0, '2024-02-14 16:29:23'),
    (4780.0, '2024-02-14 16:34:24'),
    (4110.0, '2024-02-14 16:39:24'),
    (3930.0, '2024-02-14 16:44:24'),
    (4060.0, '2024-02-14 16:49:24'),
    (   0.0, '2024-02-14 16:54:24'),
    (1170.0, '2024-02-14 16:59:24'),
    (   0.0, '2024-02-14 17:04:24'),
    (   0.0, '2024-02-14 17:09:24'),
    (   0.0, '2024-02-14 17:14:25'),
    (   0.0, '2024-02-14 17:19:25'),
    (   0.0, '2024-02-14 17:24:25'),
    (   0.0, '2024-02-14 17:29:25'),
    (   0.0, '2024-02-14 17:34:25'),
    (   0.0, '2024-02-14 17:39:25'),
    (   0.0, '2024-02-14 17:44:25'),
    (   0.0, '2024-02-14 17:49:25'),
    (   0.0, '2024-02-14 17:54:25'),
    (   0.0, '2024-02-14 17:59:25'),
    (   0.0, '2024-02-14 18:04:26'),
    (   0.0, '2024-02-14 18:09:26'),
    (   0.0, '2024-02-14 18:14:26'),
    (   0.0, '2024-02-14 18:19:26'),
    (   0.0, '2024-02-14 18:24:26'),
    (   0.0, '2024-02-14 18:29:26'),
    (   0.0, '2024-02-14 18:34:26'),
    (   0.0, '2024-02-14 18:39:26'),
    (   0.0, '2024-02-14 18:44:26'),
    (   0.0, '2024-02-14 18:49:27'),
    (   0.0, '2024-02-14 18:54:27'),
    (   0.0, '2024-02-14 18:59:27'),
    ( 230.0, '2024-02-14 19:04:27'),
    (3760.0, '2024-02-14 19:09:27'),
    (2220.0, '2024-02-14 19:14:27'),
    (   0.0, '2024-02-14 19:19:27'),
    (   0.0, '2024-02-14 19:24:27'),
    (   0.0, '2024-02-14 19:29:27'),
    (   0.0, '2024-02-14 19:34:28'),
    (2540.0, '2024-02-14 19:39:28'),
    (4070.0, '2024-02-14 19:44:28'),
    (3250.0, '2024-02-14 19:49:28'),
    (3620.0, '2024-02-14 19:54:28'),
    (1490.0, '2024-02-14 19:59:28'),
    (1590.0, '2024-02-14 20:04:28'),
    (4370.0, '2024-02-14 20:09:30'),
    (3230.0, '2024-02-14 20:14:30'),
    (3180.0, '2024-02-14 20:19:30'),
    (2600.0, '2024-02-14 20:24:30'),
    (   0.0, '2024-02-14 20:29:30'),
    (1610.0, '2024-02-14 20:34:30'),
    (3540.0, '2024-02-14 20:39:30'),
    (2750.0, '2024-02-14 20:44:30'),
    (2210.0, '2024-02-14 20:49:31'),
    (2480.0, '2024-02-14 20:54:31'),
    (2400.0, '2024-02-14 20:59:31'),
    (3310.0, '2024-02-14 21:04:31'),
    (3220.0, '2024-02-14 21:09:31'),
    (2180.0, '2024-02-14 21:14:31'),
    (2040.0, '2024-02-14 21:19:31'),
    (2320.0, '2024-02-14 21:24:31'),
    (1920.0, '2024-02-14 21:29:32'),
    (   0.0, '2024-02-14 21:34:32'),
    ( 240.0, '2024-02-14 21:39:32'),
    (3310.0, '2024-02-14 21:44:32'),
    (3100.0, '2024-02-14 21:49:32'),
    (2380.0, '2024-02-14 21:54:32'),
    (2070.0, '2024-02-14 21:59:32'),
    (2430.0, '2024-02-14 22:04:32'),
    (2630.0, '2024-02-14 22:09:32'),
    (3620.0, '2024-02-14 22:14:33'),
    (2510.0, '2024-02-14 22:19:33'),
    (2210.0, '2024-02-14 22:24:33'),
    (2090.0, '2024-02-14 22:29:33'),
    (2000.0, '2024-02-14 22:34:33'),
    ( 450.0, '2024-02-14 22:39:33'),
    (   0.0, '2024-02-14 22:44:33'),
    (   0.0, '2024-02-14 22:49:33'),
    (   0.0, '2024-02-14 22:54:33'),
    (3040.0, '2024-02-14 22:59:34'),
    (1260.0, '2024-02-14 23:04:34'),
    (5710.0, '2024-02-14 23:09:34'),
    (5420.0, '2024-02-14 23:14:34'),
    (5000.0, '2024-02-14 23:19:34'),
    (2790.0, '2024-02-14 23:24:34'),
    (5800.0, '2024-02-14 23:29:34'),
    (5200.0, '2024-02-14 23:34:34'),
    (5070.0, '2024-02-14 23:39:35'),
    (5840.0, '2024-02-14 23:44:35'),
    ( 130.0, '2024-02-14 23:49:35'),
    (3080.0, '2024-02-14 23:54:35'),
    (4440.0, '2024-02-14 23:59:35'),
    (3730.0, '2024-02-15 00:04:35'),
    (3960.0, '2024-02-15 00:09:36'),
    (3810.0, '2024-02-15 00:14:36'),
    (5420.0, '2024-02-15 00:19:37'),
    (3870.0, '2024-02-15 00:24:37'),
    (3430.0, '2024-02-15 00:29:37'),
    (3700.0, '2024-02-15 00:34:37'),
    (4130.0, '2024-02-15 00:39:37'),
    (4760.0, '2024-02-15 00:44:37'),
    (1070.0, '2024-02-15 00:49:37'),
    (3350.0, '2024-02-15 00:54:37'),
    (1560.0, '2024-02-15 00:59:38'),
    (3590.0, '2024-02-15 01:04:38'),
    (4870.0, '2024-02-15 01:09:38'),
    (3610.0, '2024-02-15 01:14:38'),
    (3410.0, '2024-02-15 01:19:38'),
    (3730.0, '2024-02-15 01:24:38'),
    ( 670.0, '2024-02-15 01:29:38'),
    (4750.0, '2024-02-15 01:34:38'),
    (3460.0, '2024-02-15 01:39:39'),
    (3380.0, '2024-02-15 01:44:39'),
    (2690.0, '2024-02-15 01:49:39'),
    (   0.0, '2024-02-15 01:54:39'),
    (   0.0, '2024-02-15 01:59:39'),
    (3770.0, '2024-02-15 02:04:39'),
    (4010.0, '2024-02-15 02:09:39'),
    (3210.0, '2024-02-15 02:14:40'),
    (3950.0, '2024-02-15 02:19:40'),
    (2780.0, '2024-02-15 02:24:40'),
    (4560.0, '2024-02-15 02:29:40'),
    (3250.0, '2024-02-15 02:34:40'),
    (3720.0, '2024-02-15 02:39:40'),
    ( 720.0, '2024-02-15 02:44:40'),
    (2730.0, '2024-02-15 02:49:40'),
    (5030.0, '2024-02-15 02:54:41'),
    (4050.0, '2024-02-15 02:59:41'),
    (3180.0, '2024-02-15 03:04:41'),
    (2180.0, '2024-02-15 03:09:41'),
    (5240.0, '2024-02-15 03:14:41'),
    (9210.0, '2024-02-15 03:19:41'),
    (2020.0, '2024-02-15 03:24:41'),
    (   0.0, '2024-02-15 03:29:41'),
    (   0.0, '2024-02-15 03:34:42'),
    (   0.0, '2024-02-15 03:39:42'),
    (   0.0, '2024-02-15 03:44:42'),
    (   0.0, '2024-02-15 03:49:42'),
    (   0.0, '2024-02-15 03:54:42'),
    (   0.0, '2024-02-15 03:59:42'),
    (   0.0, '2024-02-15 04:04:42'),
    (   0.0, '2024-02-15 04:09:42'),
    (   0.0, '2024-02-15 04:14:42'),
    (   0.0, '2024-02-15 04:19:43'),
    (   0.0, '2024-02-15 04:24:43'),
    (   0.0, '2024-02-15 04:29:43'),
    (   0.0, '2024-02-15 04:34:43'),
    (   0.0, '2024-02-15 04:39:43'),
    (   0.0, '2024-02-15 04:44:43'),
    (   0.0, '2024-02-15 04:49:43'),
    (   0.0, '2024-02-15 04:54:43'),
    (   0.0, '2024-02-15 04:59:44'),
    (   0.0, '2024-02-15 05:04:44'),
    ( 650.0, '2024-02-15 05:09:44'),
    (5880.0, '2024-02-15 05:14:44'),
    (4300.0, '2024-02-15 05:19:44'),
    (4150.0, '2024-02-15 05:24:44'),
    (   0.0, '2024-02-15 05:29:44'),
    (   0.0, '2024-02-15 05:34:44'),
    (   0.0, '2024-02-15 05:39:44'),
    (   0.0, '2024-02-15 05:44:45'),
    (3390.0, '2024-02-15 05:49:45'),
    (5120.0, '2024-02-15 05:54:45'),
    (4620.0, '2024-02-15 05:59:45'),
    (1840.0, '2024-02-15 06:04:45'),
    (   0.0, '2024-02-15 06:09:45'),
    (   0.0, '2024-02-15 06:14:45'),
    (   0.0, '2024-02-15 06:19:45'),
    (   0.0, '2024-02-15 06:24:46'),
    (   0.0, '2024-02-15 06:29:46'),
    (   0.0, '2024-02-15 06:34:46'),
    (   0.0, '2024-02-15 06:39:46'),
    (   0.0, '2024-02-15 06:44:46'),
    (   0.0, '2024-02-15 06:49:46'),
    (   0.0, '2024-02-15 06:54:46'),
    (   0.0, '2024-02-15 06:59:46'),
    (   0.0, '2024-02-15 07:04:46'),
    (   0.0, '2024-02-15 07:09:47'),
    (   0.0, '2024-02-15 07:14:47'),
    (   0.0, '2024-02-15 07:19:47'),
    (   0.0, '2024-02-15 07:24:47'),
    (   0.0, '2024-02-15 07:29:47'),
    (   0.0, '2024-02-15 07:34:47'),
    (   0.0, '2024-02-15 07:39:47'),
    (   0.0, '2024-02-15 07:44:47'),
    (   0.0, '2024-02-15 07:49:48'),
    (   0.0, '2024-02-15 07:54:48'),
    (   0.0, '2024-02-15 07:59:48'),
    (   0.0, '2024-02-15 08:04:48'),
    (   0.0, '2024-02-15 08:09:50'),
    (   0.0, '2024-02-15 08:14:50'),
    (   0.0, '2024-02-15 08:19:50'),
    (   0.0, '2024-02-15 08:24:50'),
    (   0.0, '2024-02-15 08:29:51'),
    (   0.0, '2024-02-15 08:34:51'),
    (   0.0, '2024-02-15 08:39:51'),
    (   0.0, '2024-02-15 08:44:51'),
    (   0.0, '2024-02-15 08:49:51'),
    (   0.0, '2024-02-15 08:54:51'),
    (   0.0, '2024-02-15 08:59:51'),
    (   0.0, '2024-02-15 09:04:51'),
    (   0.0, '2024-02-15 09:09:52'),
    (   0.0, '2024-02-15 09:14:52'),
    (   0.0, '2024-02-15 09:19:52'),
    (   0.0, '2024-02-15 09:24:52'),
    (   0.0, '2024-02-15 09:29:52'),
    (   0.0, '2024-02-15 09:34:52'),
    (   0.0, '2024-02-15 09:39:52'),
    (4240.0, '2024-02-15 09:44:52'),
    (5460.0, '2024-02-15 09:49:53'),
    (4330.0, '2024-02-15 09:54:53'),
    (4130.0, '2024-02-15 09:59:53'),
    (4060.0, '2024-02-15 10:04:53'),
    (4380.0, '2024-02-15 10:09:53'),
    (4660.0, '2024-02-15 10:14:53'),
    (4570.0, '2024-02-15 10:19:53'),
    (4660.0, '2024-02-15 10:24:53'),
    (5130.0, '2024-02-15 10:29:53'),
    (4870.0, '2024-02-15 10:34:54'),
    (4530.0, '2024-02-15 10:39:54'),
    (4400.0, '2024-02-15 10:44:54'),
    (4970.0, '2024-02-15 10:49:54'),
    (5520.0, '2024-02-15 10:54:54'),
    (5180.0, '2024-02-15 10:59:54'),
    (4740.0, '2024-02-15 11:04:54'),
    (4550.0, '2024-02-15 11:09:54'),
    (4520.0, '2024-02-15 11:14:55'),
    (5450.0, '2024-02-15 11:19:55'),
    (5530.0, '2024-02-15 11:24:55'),
    (5500.0, '2024-02-15 11:29:55'),
    (4220.0, '2024-02-15 11:34:55'),
    (4440.0, '2024-02-15 11:39:55'),
    (4520.0, '2024-02-15 11:44:55'),
    (4280.0, '2024-02-15 11:49:56'),
    (4470.0, '2024-02-15 11:54:56'),
    (4520.0, '2024-02-15 11:59:56'),
    (5680.0, '2024-02-15 12:04:56'),
    (2580.0, '2024-02-15 12:09:56'),
    ( 910.0, '2024-02-15 12:14:56'),
    (3130.0, '2024-02-15 12:19:56'),
    (3920.0, '2024-02-15 12:24:56'),
    (5960.0, '2024-02-15 12:29:57'),
    (4660.0, '2024-02-15 12:34:57'),
    (3990.0, '2024-02-15 12:39:57'),
    (5010.0, '2024-02-15 12:44:57'),
    (5330.0, '2024-02-15 12:49:57'),
    (4050.0, '2024-02-15 12:54:57'),
    (2700.0, '2024-02-15 12:59:57'),
    (5470.0, '2024-02-15 13:04:57'),
    (4880.0, '2024-02-15 13:09:58'),
    (5130.0, '2024-02-15 13:14:58'),
    (3320.0, '2024-02-15 13:19:58'),
    (4710.0, '2024-02-15 13:24:58'),
    (4640.0, '2024-02-15 13:29:58'),
    (5060.0, '2024-02-15 13:34:58'),
    (4860.0, '2024-02-15 13:39:58'),
    (4570.0, '2024-02-15 13:44:58'),
    (4370.0, '2024-02-15 13:49:59'),
    (4510.0, '2024-02-15 13:54:59'),
    (4460.0, '2024-02-15 13:59:59'),
    (4650.0, '2024-02-15 14:04:59'),
    (4930.0, '2024-02-15 14:09:59'),
    (4590.0, '2024-02-15 14:14:59'),
    (4680.0, '2024-02-15 14:19:59'),
    (4420.0, '2024-02-15 14:24:59'),
    (4490.0, '2024-02-15 14:30:00'),
    (4480.0, '2024-02-15 14:35:00'),
    (2190.0, '2024-02-15 14:40:00'),
    (   0.0, '2024-02-15 14:45:00'),
    (   0.0, '2024-02-15 14:50:00'),
    (   0.0, '2024-02-15 14:55:00'),
    (   0.0, '2024-02-15 15:00:00'),
    (   0.0, '2024-02-15 15:05:00'),
    (   0.0, '2024-02-15 15:10:01'),
    (   0.0, '2024-02-15 15:15:01'),
    (   0.0, '2024-02-15 15:20:01'),
    (   0.0, '2024-02-15 15:25:01'),
    (   0.0, '2024-02-15 15:30:01'),
    (   0.0, '2024-02-15 15:35:01'),
    (   0.0, '2024-02-15 15:40:01'),
    (   0.0, '2024-02-15 15:45:02'),
    (   0.0, '2024-02-15 15:50:02'),
    (   0.0, '2024-02-15 15:55:02'),
    (   0.0, '2024-02-15 16:00:02'),
    (   0.0, '2024-02-15 16:05:02'),
    (   0.0, '2024-02-15 16:10:04'),
    (   0.0, '2024-02-15 16:15:04'),
    (   0.0, '2024-02-15 16:20:04'),
    (   0.0, '2024-02-15 16:25:04'),
    (   0.0, '2024-02-15 16:30:05'),
    (   0.0, '2024-02-15 16:35:05'),
    (   0.0, '2024-02-15 16:40:05'),
    (   0.0, '2024-02-15 16:45:05'),
    (   0.0, '2024-02-15 16:50:05'),
    (   0.0, '2024-02-15 16:55:05'),
    (   0.0, '2024-02-15 17:00:05'),
    (   0.0, '2024-02-15 17:05:05'),
    (   0.0, '2024-02-15 17:10:06'),
    (   0.0, '2024-02-15 17:15:06'),
    (2160.0, '2024-02-15 17:20:06'),
    (1950.0, '2024-02-15 17:25:06'),
    (   0.0, '2024-02-15 17:30:06'),
    (   0.0, '2024-02-15 17:35:06'),
    (   0.0, '2024-02-15 17:40:06'),
    (   0.0, '2024-02-15 17:45:06'),
    (   0.0, '2024-02-15 17:50:06'),
    (   0.0, '2024-02-15 17:55:07'),
    (   0.0, '2024-02-15 18:00:07'),
    (   0.0, '2024-02-15 18:05:07'),
    (   0.0, '2024-02-15 18:10:07'),
    (   0.0, '2024-02-15 18:15:07'),
    (   0.0, '2024-02-15 18:20:07'),
    (   0.0, '2024-02-15 18:25:07'),
    (   0.0, '2024-02-15 18:30:07'),
    (   0.0, '2024-02-15 18:35:08'),
    (   0.0, '2024-02-15 18:40:08'),
    (   0.0, '2024-02-15 18:45:08'),
    (   0.0, '2024-02-15 18:50:08'),
    (   0.0, '2024-02-15 18:55:08'),
    (   0.0, '2024-02-15 19:00:08'),
    (   0.0, '2024-02-15 19:05:08'),
    (   0.0, '2024-02-15 19:10:08'),
    (   0.0, '2024-02-15 19:15:08'),
    (   0.0, '2024-02-15 19:20:09'),
    (   0.0, '2024-02-15 19:25:09'),
    (   0.0, '2024-02-15 19:30:09'),
    (   0.0, '2024-02-15 19:35:09'),
    (   0.0, '2024-02-15 19:40:09'),
    (   0.0, '2024-02-15 19:45:09'),
    (   0.0, '2024-02-15 19:50:09'),
    (3280.0, '2024-02-15 19:55:10'),
    (   0.0, '2024-02-15 20:00:10'),
    (   0.0, '2024-02-15 20:05:10'),
    (   0.0, '2024-02-15 20:10:10'),
    (   0.0, '2024-02-15 20:15:10'),
    (   0.0, '2024-02-15 20:20:10'),
    ( 350.0, '2024-02-15 20:25:10'),
    ( 870.0, '2024-02-15 20:30:11'),
    (5090.0, '2024-02-15 20:35:11'),
    (4400.0, '2024-02-15 20:40:11'),
    (4680.0, '2024-02-15 20:45:11'),
    (4780.0, '2024-02-15 20:50:11'),
    (2770.0, '2024-02-15 20:55:11'),
    (4950.0, '2024-02-15 21:00:11'),
    (4840.0, '2024-02-15 21:05:11'),
    (5670.0, '2024-02-15 21:10:12'),
    (2420.0, '2024-02-15 21:15:12'),
    (1970.0, '2024-02-15 21:20:12'),
    (2580.0, '2024-02-15 21:25:12'),
    (1400.0, '2024-02-15 21:30:12'),
    (1400.0, '2024-02-15 21:35:12'),
    (1520.0, '2024-02-15 21:40:12'),
    (4490.0, '2024-02-15 21:45:12'),
    (3770.0, '2024-02-15 21:50:13'),
    (3400.0, '2024-02-15 21:55:13'),
    (4500.0, '2024-02-15 22:00:13'),
    (2030.0, '2024-02-15 22:05:13'),
    (1520.0, '2024-02-15 22:10:13'),
    (1560.0, '2024-02-15 22:15:13'),
    (1120.0, '2024-02-15 22:20:13'),
    (   0.0, '2024-02-15 22:25:13'),
    (   0.0, '2024-02-15 22:30:14'),
    (   0.0, '2024-02-15 22:35:14'),
    (   0.0, '2024-02-15 22:40:14'),
    (   0.0, '2024-02-15 22:45:14'),
    (   0.0, '2024-02-15 22:50:14'),
    (   0.0, '2024-02-15 22:55:14'),
    (   0.0, '2024-02-15 23:00:14'),
    ( 120.0, '2024-02-15 23:05:14'),
    (3440.0, '2024-02-15 23:10:15'),
    (2170.0, '2024-02-15 23:15:15'),
    (1810.0, '2024-02-15 23:20:15'),
    (   0.0, '2024-02-15 23:25:15'),
    (   0.0, '2024-02-15 23:30:15'),
    (   0.0, '2024-02-15 23:35:15'),
    (   0.0, '2024-02-15 23:40:15'),
    (   0.0, '2024-02-15 23:45:16'),
    (   0.0, '2024-02-15 23:50:16'),
    (   0.0, '2024-02-15 23:55:16'),
    (1020.0, '2024-02-16 00:00:16'),
    (4930.0, '2024-02-16 00:05:16'),
    (5820.0, '2024-02-16 00:10:18'),
    (5520.0, '2024-02-16 00:15:18'),
    (5170.0, '2024-02-16 00:20:18'),
    (5660.0, '2024-02-16 00:25:18'),
    (3960.0, '2024-02-16 00:30:18'),
    (5150.0, '2024-02-16 00:35:18'),
    (5760.0, '2024-02-16 00:40:18'),
    (5650.0, '2024-02-16 00:45:19'),
    (5440.0, '2024-02-16 00:50:19'),
    (4920.0, '2024-02-16 00:55:19'),
    (5610.0, '2024-02-16 01:00:19'),
    (2240.0, '2024-02-16 01:05:19'),
    ( 980.0, '2024-02-16 01:10:19'),
    (6310.0, '2024-02-16 01:15:19'),
    (5710.0, '2024-02-16 01:20:19'),
    (3900.0, '2024-02-16 01:25:19'),
    (6290.0, '2024-02-16 01:30:20'),
    (5820.0, '2024-02-16 01:35:20'),
    ( 940.0, '2024-02-16 01:40:20'),
    (5970.0, '2024-02-16 01:45:20'),
    (5620.0, '2024-02-16 01:50:20'),
    (3400.0, '2024-02-16 01:55:20'),
    (3510.0, '2024-02-16 02:00:20'),
    (5740.0, '2024-02-16 02:05:20'),
    (5740.0, '2024-02-16 02:10:21'),
    (   0.0, '2024-02-16 02:15:21'),
    (   0.0, '2024-02-16 02:20:21'),
    (4490.0, '2024-02-16 02:25:21'),
    (5820.0, '2024-02-16 02:30:21'),
    (4670.0, '2024-02-16 02:35:21'),
    (1990.0, '2024-02-16 02:40:21'),
    (7980.0, '2024-02-16 02:45:21'),
    (5930.0, '2024-02-16 02:50:22'),
    (4010.0, '2024-02-16 02:55:22'),
    (6070.0, '2024-02-16 03:00:22'),
    (6000.0, '2024-02-16 03:05:22'),
    (3360.0, '2024-02-16 03:10:22'),
    (5810.0, '2024-02-16 03:15:22'),
    (5810.0, '2024-02-16 03:20:22'),
    (   0.0, '2024-02-16 03:25:22'),
    (4990.0, '2024-02-16 03:30:22'),
    (5690.0, '2024-02-16 03:35:23'),
    (4290.0, '2024-02-16 03:40:23'),
    (   0.0, '2024-02-16 03:45:23'),
    (2620.0, '2024-02-16 03:50:23'),
    (5670.0, '2024-02-16 03:55:23'),
    (5910.0, '2024-02-16 04:00:23'),
    ( 790.0, '2024-02-16 04:05:23'),
    (2060.0, '2024-02-16 04:10:23'),
    (6000.0, '2024-02-16 04:15:25'),
    (6360.0, '2024-02-16 04:20:25'),
    ( 560.0, '2024-02-16 04:25:25'),
    (   0.0, '2024-02-16 04:30:25'),
    (   0.0, '2024-02-16 04:35:25'),
    (   0.0, '2024-02-16 04:40:25'),
    (   0.0, '2024-02-16 04:45:25'),
    (   0.0, '2024-02-16 04:50:25'),
    (4440.0, '2024-02-16 04:55:26'),
    (5790.0, '2024-02-16 05:00:26'),
    (4770.0, '2024-02-16 05:05:26'),
    (   0.0, '2024-02-16 05:10:26'),
    (   0.0, '2024-02-16 05:15:26'),
    (   0.0, '2024-02-16 05:20:26'),
    (   0.0, '2024-02-16 05:25:26'),
    (   0.0, '2024-02-16 05:30:26'),
    (   0.0, '2024-02-16 05:35:27'),
    (   0.0, '2024-02-16 05:40:27'),
    (4170.0, '2024-02-16 05:45:27'),
    (6250.0, '2024-02-16 05:50:27'),
    (4550.0, '2024-02-16 05:55:27'),
    (   0.0, '2024-02-16 06:00:27'),
    (   0.0, '2024-02-16 06:05:27'),
    (   0.0, '2024-02-16 06:10:27'),
    (   0.0, '2024-02-16 06:15:28'),
    (   0.0, '2024-02-16 06:20:28'),
    (   0.0, '2024-02-16 06:25:28'),
    (   0.0, '2024-02-16 06:30:28'),
    (4350.0, '2024-02-16 06:35:28'),
    (5150.0, '2024-02-16 06:40:28'),
    (5480.0, '2024-02-16 06:45:28'),
    (   0.0, '2024-02-16 06:50:28'),
    (   0.0, '2024-02-16 06:55:29'),
    (   0.0, '2024-02-16 07:00:29'),
    (   0.0, '2024-02-16 07:05:29'),
    (   0.0, '2024-02-16 07:10:29'),
    (   0.0, '2024-02-16 07:15:29'),
    (   0.0, '2024-02-16 07:20:29'),
    (   0.0, '2024-02-16 07:25:29'),
    (   0.0, '2024-02-16 07:30:29'),
    (2030.0, '2024-02-16 07:35:30'),
    (4780.0, '2024-02-16 07:40:30'),
    (5100.0, '2024-02-16 07:45:30'),
    (3640.0, '2024-02-16 07:50:30'),
    (4090.0, '2024-02-16 07:55:30'),
    (5070.0, '2024-02-16 08:00:30'),
    (5260.0, '2024-02-16 08:05:30'),
    (   0.0, '2024-02-16 08:10:32'),
    (   0.0, '2024-02-16 08:15:32'),
    (   0.0, '2024-02-16 08:20:32'),
    (   0.0, '2024-02-16 08:25:32'),
    (1290.0, '2024-02-16 08:30:32'),
    (5320.0, '2024-02-16 08:35:32'),
    (5080.0, '2024-02-16 08:40:32'),
    (4700.0, '2024-02-16 08:45:32'),
    (4600.0, '2024-02-16 08:50:33'),
    (1540.0, '2024-02-16 08:55:33'),
    (   0.0, '2024-02-16 09:00:33'),
    (2900.0, '2024-02-16 09:05:33'),
    (5210.0, '2024-02-16 09:10:33'),
    (5150.0, '2024-02-16 09:15:33'),
    (4960.0, '2024-02-16 09:20:33'),
    (4980.0, '2024-02-16 09:25:33'),
    (5200.0, '2024-02-16 09:30:33'),
    (4880.0, '2024-02-16 09:35:34'),
    (4760.0, '2024-02-16 09:40:34'),
    (5480.0, '2024-02-16 09:45:34'),
    (4690.0, '2024-02-16 09:50:34'),
    (4520.0, '2024-02-16 09:55:34'),
    (4860.0, '2024-02-16 10:00:34'),
    (4530.0, '2024-02-16 10:05:34'),
    (5210.0, '2024-02-16 10:10:34'),
    (5290.0, '2024-02-16 10:15:35'),
    (3750.0, '2024-02-16 10:20:35'),
    (1970.0, '2024-02-16 10:25:35'),
    (4640.0, '2024-02-16 10:30:35'),
    (4700.0, '2024-02-16 10:35:35'),
    (4900.0, '2024-02-16 10:40:35'),
    (4460.0, '2024-02-16 10:45:36'),
    (5310.0, '2024-02-16 10:50:36'),
    (5090.0, '2024-02-16 10:55:37'),
    (5300.0, '2024-02-16 11:00:37'),
    (5190.0, '2024-02-16 11:05:37'),
    (5190.0, '2024-02-16 11:10:37'),
    (1770.0, '2024-02-16 11:15:37'),
    (4560.0, '2024-02-16 11:20:37'),
    (5120.0, '2024-02-16 11:25:37'),
    (4450.0, '2024-02-16 11:30:37'),
    (4140.0, '2024-02-16 11:35:37'),
    (4810.0, '2024-02-16 11:40:38'),
    (   0.0, '2024-02-16 11:45:38'),
    (   0.0, '2024-02-16 11:50:38'),
    (   0.0, '2024-02-16 11:55:38'),
    (   0.0, '2024-02-16 12:00:38'),
    (   0.0, '2024-02-16 12:05:38'),
    (   0.0, '2024-02-16 12:10:39'),
    (   0.0, '2024-02-16 12:15:39'),
    (   0.0, '2024-02-16 12:20:40'),
    (   0.0, '2024-02-16 12:25:40'),
    (   0.0, '2024-02-16 12:30:40'),
    (   0.0, '2024-02-16 12:35:40'),
    (   0.0, '2024-02-16 12:40:40'),
    (   0.0, '2024-02-16 12:45:40'),
    (   0.0, '2024-02-16 12:50:40'),
    (   0.0, '2024-02-16 12:55:40'),
    (   0.0, '2024-02-16 13:00:40'),
    (   0.0, '2024-02-16 13:05:41'),
    (   0.0, '2024-02-16 13:10:41'),
    (   0.0, '2024-02-16 13:15:41'),
    (   0.0, '2024-02-16 13:20:41'),
    (   0.0, '2024-02-16 13:25:41'),
    (   0.0, '2024-02-16 13:30:41'),
    (   0.0, '2024-02-16 13:35:41'),
    (   0.0, '2024-02-16 13:40:41'),
    (   0.0, '2024-02-16 13:45:42'),
    (   0.0, '2024-02-16 13:50:42'),
    (   0.0, '2024-02-16 13:55:42'),
    (   0.0, '2024-02-16 14:00:42'),
    (   0.0, '2024-02-16 14:05:42'),
    (   0.0, '2024-02-16 14:10:42'),
    (   0.0, '2024-02-16 14:15:42'),
    (   0.0, '2024-02-16 14:20:42'),
    (   0.0, '2024-02-16 14:25:43'),
    (   0.0, '2024-02-16 14:30:43'),
    (   0.0, '2024-02-16 14:35:43'),
    (   0.0, '2024-02-16 14:40:43'),
    (   0.0, '2024-02-16 14:45:43'),
    (   0.0, '2024-02-16 14:50:43'),
    (   0.0, '2024-02-16 14:55:43'),
    (   0.0, '2024-02-16 15:00:44'),
    (   0.0, '2024-02-16 15:05:44'),
    (   0.0, '2024-02-16 15:10:44'),
    (   0.0, '2024-02-16 15:15:44'),
    (   0.0, '2024-02-16 15:20:44'),
    (   0.0, '2024-02-16 15:25:44'),
    (   0.0, '2024-02-16 15:30:44'),
    (   0.0, '2024-02-16 15:35:44'),
    (   0.0, '2024-02-16 15:40:45'),
    (   0.0, '2024-02-16 15:45:45'),
    (   0.0, '2024-02-16 15:50:45'),
    (   0.0, '2024-02-16 15:55:45'),
    (   0.0, '2024-02-16 16:00:45'),
    (   0.0, '2024-02-16 16:05:45'),
    (   0.0, '2024-02-16 16:10:45'),
    (   0.0, '2024-02-16 16:15:45'),
    (   0.0, '2024-02-16 16:20:46'),
    (   0.0, '2024-02-16 16:25:46'),
    (   0.0, '2024-02-16 16:30:46'),
    (   0.0, '2024-02-16 16:35:46'),
    (   0.0, '2024-02-16 16:40:46'),
    (   0.0, '2024-02-16 16:45:46'),
    (   0.0, '2024-02-16 16:50:46'),
    (   0.0, '2024-02-16 16:55:46'),
    (   0.0, '2024-02-16 17:00:46'),
    (   0.0, '2024-02-16 17:05:47'),
    (   0.0, '2024-02-16 17:10:47'),
    (   0.0, '2024-02-16 17:15:47'),
    (   0.0, '2024-02-16 17:20:47'),
    (   0.0, '2024-02-16 17:25:47'),
    (   0.0, '2024-02-16 17:30:47'),
    (   0.0, '2024-02-16 17:35:47'),
    (   0.0, '2024-02-16 17:40:47'),
    (   0.0, '2024-02-16 17:45:47'),
    (   0.0, '2024-02-16 17:50:48'),
    (   0.0, '2024-02-16 17:55:48'),
    (   0.0, '2024-02-16 18:00:48')

/*
What I would like to see

    Date   / DayshiftTotal/ NightshiftTotal/TotalWeight
02/16/2024 /   215,450    /     346,530    / 561,980  -- Match (after missing data added)
02/15/2024 /   274,270    /     318,460    / 592,730  -- Match
02/14/2024 /   472,570    /     293,010    / 765,580  -- Above data is incomplete
02/13/2024 /   394,480    /     541,580   / 936,060  -- Above data is missing
*/
715 rows affected

-- Calculate inclusive start and exclusive end dates for the current month
DECLARE @FromDate DATETIME = DATETRUNC(month, GETDATE()) -- '2024-02-01'
DECLARE @ToDate DATETIME = DATEADD(month, 1, @FromDate) -- Exclusive

-- Since a night shift is applied to the following (ending) day, we need
-- to adjust the start/end date/times to be 18:05 on the preceding day.
DECLARE @MinutesAdjust INT = -1440 + 18 * 60 + 5 -- Minus 1 day plus 18:05
DECLARE @FromDateTime DATETIME = DATEADD(minute, @MinutesAdjust, @FromDate)
DECLARE @ToDateTime DATETIME = DATEADD(minute,  @MinutesAdjust, @ToDate)

DECLARE @ShiftOrigin DATETIME = '1900-01-01 06:05' -- DATE_BUCKET reference date/time
DECLARE @ShiftMinutes INT = 12 * 60  -- 12 hours shifts
  
SELECT
    D.ShiftEndDate,
    SUM(CASE WHEN D.ShiftStartTime = '06:05' THEN W.TotalWeight ELSE 0 END) AS DayShiftTotal,
    SUM(CASE WHEN D.ShiftStartTime = '18:05' THEN W.TotalWeight ELSE 0 END) AS NightShiftTotal,
    SUM(W.TotalWeight) AS TotalWeight
FROM DryerHopperWeightTotal W
CROSS APPLY (
    SELECT DATE_BUCKET(minute, @ShiftMinutes, W.DateTm, @ShiftOrigin) AS ShiftStart
) S
CROSS APPLY (
    SELECT
        CAST(S.ShiftStart AS DATE) AS ShiftStartDate,
        CAST(S.ShiftStart AS TIME) AS ShiftStartTime,
        CAST(DATEADD(hour, 12, S.ShiftStart) AS DATE) AS ShiftEndDate
) D
WHERE W.DateTm >=  @FromDateTime AND W.DateTm < @ToDateTime
GROUP BY D.ShiftEndDate
ORDER BY D.ShiftEndDate DESC


ShiftEndDate
DayShiftTotal
NightShiftTotal
TotalWeight


2024-02-16
215450.0
346530.0
561980.0

2024-02-15
274270.0
318460.0
592730.0

2024-02-14
460370.0
0.0
460370.0


-- Version for use with SQL Server versions prior to 2022

-- Calculate inclusive start and exclusive end dates for the current month
DECLARE @FromDate DATETIME = DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) -- '2024-02-01'
DECLARE @ToDate DATETIME = DATEADD(month, 1, @FromDate) -- Exclusive

-- Since a night shift is applied to the following (ending) day, we need
-- to adjust the start/end date/times to be 18:05 on the preceding day.
DECLARE @MinutesAdjust INT = -1440 + 18 * 60 + 5 -- Minus 1 day plus 18:05
DECLARE @FromDateTime DATETIME = DATEADD(minute, @MinutesAdjust, @FromDate)
DECLARE @ToDateTime DATETIME = DATEADD(minute,  @MinutesAdjust, @ToDate)

DECLARE @ShiftOrigin DATETIME = '1900-01-01 06:05' -- DATE_BUCKET reference date/time
DECLARE @ShiftMinutes INT = 12 * 60  -- 12 hours shifts

SELECT
    D.ShiftEndDate,
    SUM(CASE WHEN D.ShiftStartTime = '06:05' THEN W.TotalWeight ELSE 0 END) AS DayShiftTotal,
    SUM(CASE WHEN D.ShiftStartTime = '18:05' THEN W.TotalWeight ELSE 0 END) AS NightShiftTotal,
    SUM(W.TotalWeight) AS TotalWeight
FROM DryerHopperWeightTotal W
CROSS APPLY (
    SELECT DATEADD(minute,
                  DATEDIFF(minute, @ShiftOrigin, W.DateTm) / @ShiftMinutes * @ShiftMinutes,
                  @ShiftOrigin
                 ) AS ShiftStart
) S
CROSS APPLY (
    SELECT
        CAST(S.ShiftStart AS DATE) AS ShiftStartDate,
        CAST(S.ShiftStart AS TIME) AS ShiftStartTime,
        CAST(DATEADD(hour, 12, S.ShiftStart) AS DATE) AS ShiftEndDate
) D
WHERE W.DateTm >=  @FromDateTime AND W.DateTm < @ToDateTime
GROUP BY D.ShiftEndDate
ORDER BY D.ShiftEndDate DESC


ShiftEndDate
DayShiftTotal
NightShiftTotal
TotalWeight


2024-02-16
215450.0
346530.0
561980.0

2024-02-15
274270.0
318460.0
592730.0

2024-02-14
460370.0
0.0
460370.0
ShiftEndDate	DayShiftTotal	NightShiftTotal	TotalWeight
2024-02-16	215450.0	346530.0	561980.0
2024-02-15	274270.0	318460.0	592730.0
2024-02-14	460370.0	0.0	460370.0