Hi All,
I want to write a fix script to insert new records using existing values.
I have a table:- u_test
inside that there are 4 attributes: -
| Patching | Start | End | Week (reference field) |
| Sat 01:00 -4:00 | 14:00:00 | 18:00:00 | first week |
| Fri 02:00 -5:00 | 15:00:00 | 16:00:00 | first week |
| Sun 00:00 -03:00 | 15:00:00 | 20:00:00 | first week |
For weeks I have:- [week2, week3, week4] (reference value)
with each week i want to create new records with same patching, start and end .
I want to make new records with same values Just week needs to be changed to third week. So i need to insert 3 records with same start, end and patching Just need to update week field without updating the actual record.
