I'm looking for a MS SQL query for SQL 2000 where I can count records within 5 minute intervals. Once I have this data I'm going to use it to chart the numbers so I will want to write it to a new table and be able to go backward through my existing data. Additionally I want to do this going forward, presumably with DTS.?
Thanks in advance.