Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Comparing data for a certain day of the week by month for every year RE: Comparing data for a certain day of the week by month for every year

  • October 23, 2014 at 1:37 am

    #1754253

    vee_jess (10/22/2014)

    Hi Cris,

    As a title will be best please.

    Also, please note that I need to report on data October,November and December 2012,2013 and 2014. Now, I will get

    4 Mondays in October 2012 against 4 Mondays in October 2013 against 4 Mondays in October 2014. Same pattern for the 7 days of the week and for November and December.

    Thanks

    How do you want the data laid out? The months could be column-wise or row-wise. Begin with the spreadsheet snapshot you've already posted and adjust it to show where the values for the different months should appear.

    “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