My question is this:
I have a table which looks like this below:
week1 week2 week3 week4 .... week 78
I want to roll week1 data to week2, week2 to week3....etc..
What is the best method to use for both data integrity and performance?
ie) 1. rename week1 to week2 etc week 78 would be deleted
2. bulk update method?
Any insight would be greatly appreciated..