Home Forums SQLServerCentral.com Anything that is NOT about SQL! Day-of-week to Week-Number mapping RE: Day-of-week to Week-Number mapping

  • March 16, 2017 at 7:32 am

    #1933464

    Sergiy - Wednesday, March 15, 2017 10:42 PM

    Hi,
    Here is the problem I'm not sure how to resolve.
    May be somebody faced something similar and can give me an idea where to start.

    I've got a new set of socks which are marked with week day names: "Monday", "Tuesday", etc.
    My best guess is that it must indicate on which week I should wear which pair of socks.
    But I'm not sure how do I convert the week days into week numbers(?).

    Does anybody know what is the rule to apply here?

    Please provide detailed instructions for creating and setting up your loom. What colour is your cotton?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden