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

Bryan Carbonnell carbonnb at gmail.com
Fri Jan 12 11:03:35 CST 2007


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!"



More information about the dba-SQLServer mailing list