This content has been marked as final. Show 3 replies
We have A BIG table (TAB1) where lots of transactions are inserted (12 rows every second). This table is reset to 0 every midnight. Starting at 1AM, at the end of every hour, on top of the hour, I have to sum all amounts in the table for the firsts hour and print a summary report for the hr. And do this for the next hours. How can I do this per hour?