I have database items that I need to accumulate activity for based on weeks
of the year(multiple years). Similar to calendar based apps only this is
a grid display.
Example:
date daily total weekly total
01-01-2001 3 3
01-03-2001 2 5
01-08-2001 4 4
How can I do this efficiently real time?