I want to have a SQL query can return the max value for a given time
range. Let me give an example which can clear up what I mean:
Over all the data we have, what is the value for the largest two hour
period?

My investigations lend me to believe this can be done via a Range
Window. Since SQL Server has yet to implement this capability, I was
wondering if anyone knew of a viable workaround.

Thank for any help in advance.

Geoff

Challenging Query - Please Help
JOIN Question...
create a sp from query output
Combine records to calculate
Creative solution to relatively simply requirement