>I don't think this is possible in one SQL statement.
>What you might try is creating one SQL-statement for every day and then join the data of all the statements together.
That may be faster for large sets of data, but IMO isn't worth the effort. Large set would be something running into thousands or tens of thousands of records - any I doubt there's that much data, specially on any such report. I mean, even at a few thousand, who would read that report?
The downside of such a seven-fold join is its clumsiness. It seems to be more code and less elegant than a simple loop. I have such a piece of code (which breaks datetimes in a day into eight three-hour segments) and the loop contains only three statements.