Hourly sales report

[RickH]

Have a look here, should work in V4 or V5

Sales Per Hour Report

Here we go … this will work in v4 or v5. Set the first 2 declarations to use ‘{Start}’ and ‘{End}’ respectively if you want to use this SQL in a Report. Set the next 2 declarations for the First and Last hour that you want results for. These could also be parameterized as @1 and @2 if you are going to feed the values into the SQL via a Report. declare @StartDate datetime = '2015-01-02T00:00:00.000' -- use '{Start}' here declare @EndDate datetime = '2015-01-02T23:59:59.000' -- use '{End}' h…