SQL Table Summary - Best Method?

I would like to retreive a summary result from the data stored in a table, but I'm unsure what is the best method. The data looks like the following:

dummy numbers are used in the start and end time just to show the data.

Event Start_Time(epoch_seconds) End_Time(epoch_seconds)

1            99978977                                    99879849
1            99978977                                    99879849
1            99978977                                    99879849
1            99978977                                    99879849
1            99978977                                    99879849

I want to sum the # of Events hourly shown over a period of several days. What would be the best way about doing this given that the data will be eventually dumped to a web page. Should I use a stored procedure and if so does anyone have an example? Generate a summary table, however, I've always been told don't store calculated data or should I just generate multiple queries dynamically to fullfil the request of the user. Received on Sat Dec 16 2000 - 17:05:16 CST