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 22, 2014 at 6:35 am

    #1754016

    Hi Chris,

    Thank you. If I understood correctly, the piece of code will generate all the dates, 2 years back from today, with the day name and the week they fall in the month and this should be used as the base of my query left join to this my dataset. I'm still not sure how is this going to group all the parcelcount for all Mondays, all Tuesdays, etc by Stacks by year?

    Please excuse my ignorance but I may be missing something. What I'm finding difficult is how to group first Monday of November 2012 with the first Monday of November 2013 with first Monday November 2014. Do the same for Second Monday, etc and for Tuesdays ect...

    J.