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

8 votes203 views1 answer
Oracle current date plus 1 month
SQL
3 votes193 views4 answers
Mysql delete duplicate rows
SQL
0 vote263 views1 answer
Hierarchal database table
SQL
1 vote212 views2 answers
Grab part of a string sql
SQL
0 vote198 views1 answer
Replace \n sql
SQL
0 vote209 views1 answer
Sql server count all tables rows
SQL
0 vote198 views1 answer
Sql count total by foreign key
SQL
0 vote192 views2 answers
Drop check constraint in ms sql
SQL
0 vote187 views1 answer
Mysql events not work
SQL
1 vote206 views1 answer
Sql server datetime vs datetime2
SQL