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

2 votes227 views2 answers
Install postgresql
SQL
2 votes191 views1 answer
Drop table purge
SQL
2 votes198 views1 answer
Cast string to datetime mysql
SQL
8 votes329 views2 answers
Oracle auto increment primary key
SQL
0 vote203 views1 answer
Kill a pid redshift
SQL
2 votes209 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote206 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote205 views3 answers
Mysql parse int
SQL
0 vote206 views1 answer
Mysql a from on this page has
SQL
1 vote203 views2 answers
Begin transaction in sql
SQL