[dba-SQLServer] Holidays by Nation andState/Province/Canton/etc.

Martin Reid mwp.reid at qub.ac.uk
Fri Jan 12 11:12:14 CST 2007


You can also have a working week which can be any combination of days at all.
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Bryan Carbonnell
Sent: Fri 12/01/2007 17:03
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Holidays by Nation andState/Province/Canton/etc.



On 1/12/07, artful at rogers.com <artful at rogers.com> wrote:
> As it happens, I know several friends who own and operate bars/taverns/restaurants. These folks do not operate on the assumption that Saturday and Sunday are days off: precisely the opposite in fact. So the concept of "weekends" has to go. My good friend Jerry for example works Saturday and Sunday and considers his weekend Monday and Tuesday,
>
> I am unsure how to model this.

Well, at work we have folks that work shift work all over the place,
so the concept of weekends are only for those of us that work in the
office.

instead we use the concept of Days Off, not weekends. Your days off, 2
per week which is Monday to Sunday, can be anything, but they have to
be consecutive. So for those folks, there are 5 business days and 2
Days off per week.

So that may be one way to model it, a week has 5 business days and 2
days off. It doesn't really matter which specific days they are.

--
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 





More information about the dba-SQLServer mailing list