Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-16 : 18:33:49
|
Chris writes "Situation:
I have a log table with several records (> 2 Mil) which is only going to get bigger. I am developing an ASP reporter to group the record counts by hour of day, daily, weekly, monthly, etc. All of the major processing will be on on SQL Server 7.0 (server is fully loaded).
Question:
Is there a way to get the dates to "group" other than using the DATEPART function? Right now I am thinking about dynamically building the SELECT and GROUP BY clause with a parameter specified at runtime and use a CASE statement, but I am not sure if there is a more "optimal" way of doing this.
Advice is welcome.
Chris" |
|
|
|
|
|
Date grouping and summaries (hr, day, wk, mo)