SQL Server 2019. This query isn't quite working. I need to create a new column with a sum of all the values of metered barrels based on daily 9am-9am increments.
SELECT [TicketDate]
,[MeteredBarrels]
,[ProductHaul]
FROM RunTicketsTEST
WHERE ProductHaul like 'Condensate';
SELECT * from Cond24Hr;
DECLARE @BeginDate datetime = '2021-01-01';
DECLARE @EndDate datetime = GETDATE();
SET @BeginDate = DATEADD(HOUR, 9, @BeginDate);
SET @EndDate = DATEADD(HOUR, @BeginDate+24, @EndDate);
SELECT SUM(meteredbarrels) as '24Hr'
FROM Cond24Hr
WHILE
DATEADD(HOUR, 9, [TicketDate]) BETWEEN @BeginDate AND @EndDate;