Home Forums SQL Server 2014 Development - SQL Server 2014 count the order on weekly basis RE: count the order on weekly basis

  • March 10, 2014 at 9:41 am

    #1695596

    Koen Verbeeck (3/10/2014)

    That is fascinating.

    Is there also a question?

    Hint: read the links How to post forum questions[/url] and Need an answer? No, you need a question.

    ps: just to shove you in the right direction: group by week (use the DATEPART function to find the week) and count the orders.

    Instead of DATEPART, I would suggest a date calculation to get the first (or last) day of the week to group by it as it would be more descriptive.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2