presently i am working on designing Timetable builder, i completed designing and updating. I did timetable for one week every week it changes and some times it may be same as last week.
Now the point is "Same as previous week" button, when i click on this button i need to
1) update old five to be disabled (last week date records status=0)
2) inserting these old five records with new week dates (status=1)
I want to do these two operation at same time in stored procedure.