Forum Discussion
Running count hourly from table with no timestamp
Thanks for your help!!
I dont want to retrieve the time of my report run and writing it to sql.
I just want to run the report at fixed hour of the day and then counting the records between different sets of hours.
like I am able to retrieve the data like this
Time countof orders
9AM 69
at 10 AM
9AM 60
10AM 60
at 11AM
9AM 57
10AM 57
11AM 57
(Report will be run at fixed hours, after every one hour)
My problem is , I am unable to retain the count for the prvious hours
I want output like this
9AM 69
10AM 60
11AM 57
is this possible ?
Please note my table doent have timestamp. I created a new calendar table with date and time and joined this date coulumn with date column of my table
Please help...
The more I think about this, the more I think that you should really go back and arrange to get a timestamp added to your data. If someone wants to do a report BY HOUR, then its only reasonable that they need to provide a timestamp.