Now I have my meters in place now I need a total for each day. here is the query I have.
SELECT MdbDeviceID, Volume, Energy, DailyFlowDateTime
WHERE (MdbDeviceID NOT IN (1, 3, 17, 18, 238, 239, 240, 241, 242, 243, 244)) and (DailyFlowDateTime >= @StartDate) AND (DailyFlowDateTime <= @EndDate)
ORDER BY DailyFlowDateTime DESC
this is query is giving me the value for each meter. I need a total off all meters for each day.
by the guys thanks for the help.