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/>