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

3 votes293 views1 answer
Sql datetime as date
SQL
0 vote305 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote342 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote320 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote288 views1 answer
Postpresql relation not found
SQL
0 vote294 views1 answer
Sql string length postgresql
SQL
-1 vote292 views1 answer
Export mysql table to file
SQL
0 vote309 views1 answer
Max mysql
SQL
0 vote303 views1 answer
Unique index in mysql
SQL
0 vote314 views1 answer
How to insert a uniqueidentifier in sql
SQL