I have one table with +500K records. The records consist of transactions.
12 December 2011 +1
14 December 2011 +4
18 December 2011 -1
For someone who can do this, this is pretty easy. I need someone today who can create query that makes able to select a period and and merge these transactions to 1 transaction for all the users within that period. So above becomes one record called Archive with +5.
This also needs to be done today. So if you bid, make sure to start right away.