
July 23rd, 2008, 10:04 AM
|
Registered User
|
|
Join Date: Jul 2008
Posts: 1
Time spent in forums: 6 m 33 sec
Reputation Power: 0
|
|
Calculate transactions for each hour
Hi, I have a table which has columns:
CURRTIME|SERVERNAME|QUEUES|MSGCOUNT
07-21-2008 12:00:30|testserver|QueueName1|52836
07-21-2008 13:00:46|testserver|QueueName1|59108
07-21-2008 12:00:37|testserver|QueueName2|32875
07-21-2008 13:00:46|testserver|QueueName1|42210
....
Can you guys please help me in creating a new table:
STARTTIME|ENDTIME|SERVERNAME|QUEUES|MSGCOUNT
07-21-2008 12:00:30|07-21-2008 13:00:46|testserver|QueueName1|6272
....
6272 is the difference of the two MSGCOUNT rows.
Ideally, we'll have the data of every one hour, and we'll have to calculate the transactions of each hour for one day.
Please help !!!
|