1 - Do you mean natively or the way I have the db set up? If it's the latter, I don't have any constraints for overlaps in the db design. Each "shift" or date range is its own record. The id is an identity field.
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 12/2/2003 9:57:43 AM >>>
>
> The problems are:
>
> 1) I can't figure out what should be in the WHERE clause.
Does your database support OVERLAPS?
> 2) Have I screwed myself by chopping up the dates?
Screwed is not a nice word, but you did make things difficult for
yourself.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
