Posted by AndrewC on 04/27/07 14:04

Erland Sommarskog wrote:
> Nate (nate.borland@westecnow.com) writes:
>> I am looking to populate a Schedule table with information from two
>> other tables. I am able to populate it row by row, but I have created
>> tables that should provide all necessary information for me to be able
>> to automatically populate a "generic" schedule for a few weeks or more
>> at a time.
>>
>> The schedule table contains:
>> (pk) schedule_id, start_datetime, end_datetime, shift_employee,
>> shift_position
>>
>>
>> A DaysOff table contains:
>> (pk) emp_id, dayoff_1, dayoff_2 <-- the days off are entered in day
>> of
>> week (1-7) form
>>
>>
>> A CalendarDays table contains:
>> (pk) date, calendar_dow <-- dow contains the day of week number (as
>> above) for each day until 2010.
>>
>>
>> My main question is how to put all of this information together and
>> have SQL populate the rows with data based on days off. Any
>> suggestions?
>
> Just as a reminder, in case you are getting old and don't remember
> what you did yesterday, you posted this question yesterday as well,
> and I replied by asking some questions, and Plamen Ratchev suggested
> some queries. I suggest that you go Google news and find the old
> thread and review our replies.
>
>
Hmm. I'm getting old and I don't do daft things like that!
Now, what was I doing before I read this?....

[Back to original message]