Populate a Table with Stored Proc.

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?

.

Relevant Pages

  • Re: After date entered, populate additional dates in other fields
    ... Currently we are using an Excell speadsheet and that is the way it is setup. ... schedule based on any beginning date, having it fill in already previously ... After the date entrys I want to populate the date in fields Wk1Date1 through ...
    (microsoft.public.access.formscoding)
  • Populate table with stored proc
    ... I am looking to populate a Schedule table with information from two ... A CalendarDays table contains: ... have SQL populate the rows with data based on days off, ...
    (comp.databases.ms-sqlserver)
  • Re: After date entered, populate additional dates in other fields
    ... First off, if it is always a 2 week payroll, why insert a Wk2Date? ... schedule based on any beginning date, having it fill in already previously ... After the date entrys I want to populate the date in fields Wk1Date1 through ...
    (microsoft.public.access.formscoding)
  • two questions
    ... existing schedule and expected the value in that field to automatically ... populate but it did not. ... Jack ... Prev by Date: ...
    (microsoft.public.project)