I need to select from a table and format the output like so (total is a SUM(value)):<BR><BR><pre class="ip-ubbcode-code-pre"> That's not what the SQL engine is for ...

</pre><BR><BR>And you see the gaps that i'm talking about.<BR><BR>Now the brute force method to this is to create a table so with all the hours in it for my date range so that there's at least one ...