I thought you were looking for records where the hour was between 06:00 & 18:00, but your query says between 08:00 & 14:00...
Thomas, I changed it around just testing... Honestly I was just using 06:00 and 18:00 as a baseline, but even if I sent the time to 11:00 & 12:00 it still shows the same percentage of usage at it does for a 24 hour day, so I know that data is incorrect it should be much less for a 1 hour window.
Hang on - are these the percentages that are calculated in the functions GetInBps95 etc? Those functions appear to take a date range only - perhaps this is where the problem is?
Thomas Rushton
blog: https://thelonedba.wordpress.com