I noticed you were in the US and have an expat's website. Also that i appears you own/run this whole website! It's been really useful so far!
I will try those ideas/comments you had about the undo/rollback. Just don't understand why i need to be able to undo stuff...
i am doing this [pseudo code];
Code:
get the first date in the database
get the last date in the database
all dates now in UTC curtosy of java.text.simpledateformat!
do this to each of the above
trunc(dateinUTC/604800)*604800
for x=first to last date, step by a week
update colx for allrecords in this week to contian x
commit
for each record with colx=x
assignit a unique number incrementing from 120
commit
reformat a bitmasked number
update upto three columns depending upon the result
commit
Anyway; it's gone seven - meant to have left at 3:45pm
.
If ya come back to the uk, that pint offer still stands!