I need to add data into a SQL Server table.
The data to be added is a bi-weekly schedule, that needs to be repeated till the end of the year.
During even weeks the schedule looks like: SCHEDULE 1
During uneven weeks it is: SCHEDULE 2
Data must be entered starting from Tuesday januari 1th 2013 (in week one) current date.
Week 1 will be entered as follows:
Week 2 will be entered as follows:
Week 3 will be entered as follows:
How can this be done in an easy way?