Re: Populate a Table with Stored Proc.
- From: AndrewC <andrew@xxxxxxxxxxxxxxxxx>
- Date: Fri, 27 Apr 2007 15:04:09 +0100
Erland Sommarskog wrote:
Nate (nate.borland@xxxxxxxxxxxxx) writes:Hmm. I'm getting old and I don't do daft things like that!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.
Now, what was I doing before I read this?....
.
- References:
- Populate a Table with Stored Proc.
- From: Nate
- Re: Populate a Table with Stored Proc.
- From: Erland Sommarskog
- Populate a Table with Stored Proc.
- Prev by Date: Re: getdate() problem: where is the time taken from ?
- Next by Date: Re: sql script
- Previous by thread: Re: Populate a Table with Stored Proc.
- Next by thread: getdate() problem: where is the time taken from ?
- Index(es):
Relevant Pages
|
