General information
Forum:
Microsoft SQL Server
Im havnig problems getting this query to work right. What I have is a table of logins to a website. In the table containes the dattime of the loging along with other info. I need a query containing the number of logins within every 10 minute time interval.
For example
1/1/02 12:00 pm to 1/1/02 12:10 pm - 10 logins
1/1/02 12:10 pm to 1/1/02 12:20 pm - 15 logins
1/1/02 12:20 pm to 1/1/02 12:30 pm - 6 logins
...
I hope this makes sence. Any ideas?
Eric Stephani
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only