Home Forums Article Discussions Article Discussions by Author Discuss content posted by Todd Fifield Calendar Tables III - Changing Business Rules RE: Calendar Tables III - Changing Business Rules

  • February 17, 2011 at 12:20 pm

    #1288448

    ziangij (2/16/2011)

    thanks for this post 🙂

    One question - will it be good to add a column instead - say IsWeekEnd, IsWeekStart. Will it fare better or worse than the current query ?

    Thanks in advance.

    Ziangij,

    I've tried it both ways. Usually just using the date itself works better and you don't have to add any unnecessary flags to the tables.

    Todd Fifield