Stef Merlijn
asked on
Stored procedure that increase date for bi-weekly schedule
Hi,
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:
01-01-2013 Level2
03-01-2013 Level2
04-01-2013 Level1
05-01-2013 Level2
Week 2 will be entered as follows:
07-01-2013 Level1
08-01-2013 Level2
09-01-2013 Level1
10-01-2013 Level2
Week 3 will be entered as follows:
14-01-2013 Level1
15-01-2013 Level2
17-01-2013 Level2
18-01-2013 Level1
19-01-2013 Level2
etc. etc.
How can this be done in an easy way?
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
Monday Level1
Tuesday Level2
Wednesday Level1
Thursday Level2
During uneven weeks it is: SCHEDULE 2
Monday Level1
Tuesday Level2
Thursday Level2
Friday Level1
Saturday Level2
Data must be entered starting from Tuesday januari 1th 2013 (in week one) current date.
Week 1 will be entered as follows:
01-01-2013 Level2
03-01-2013 Level2
04-01-2013 Level1
05-01-2013 Level2
Week 2 will be entered as follows:
07-01-2013 Level1
08-01-2013 Level2
09-01-2013 Level1
10-01-2013 Level2
Week 3 will be entered as follows:
14-01-2013 Level1
15-01-2013 Level2
17-01-2013 Level2
18-01-2013 Level1
19-01-2013 Level2
etc. etc.
How can this be done in an easy way?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER