Home Forums SQL Server 2008 T-SQL (SS2K8) Trying to calculate employees working pattern RE: Trying to calculate employees working pattern

  • November 14, 2012 at 1:00 pm

    #1559094

    i have a question about #Working_Pattern. This table holds the days of the week an employee works with the start date being the date the new schedule became effective?

    I think i have a very efficient method using a calendar table if that is correct.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]