>>http://social.technet.microsoft.com/wiki/contents/articles/25654.t-sql-find-the-peak-hour.aspx
>
>Goodness! I'm famous.
>
>:)
>
>Thank you for the heads up. What does he mean when he speaks about the "correctly designed table"? Is he suggesting there might be a better table structure for my data? He doesn't really give much help there.

By correctly designed table it means one row for each date/time instead of 96 columns.

BTW, who is he? I wrote that article.