Add week ending date sql server

SELECT  
    DATEADD(DAY, 7 - DATEPART(WEEKDAY, orderDate), CAST(orderDate AS DATE)) AS ordersPerWeek, 
    sum(orderAmount) AS orderSumForGrouping, 
    count(1) AS numberOfOrdersWithinGrouping
FROM    @table o
GROUP   BY DATEADD(DAY, 7 - DATEPART(WEEKDAY, orderDate), CAST(orderDate AS DATE))

Source: stackoverflow.com

Similar codes

79 votes357 views6 answers
Grepper code
SQL
0 vote155 views1 answer
Custom row number
SQL
0 vote156 views1 answer
Sum sqlserver
SQL
3 votes149 views2 answers
Mysql HAVING
SQL
13 votes153 views3 answers
Uninstall mysql centos 7
SQL
0 vote145 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote140 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote160 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote221 views1 answer
Trigger
SQL
1 vote185 views1 answer
Postgresql blocked on mac
SQL