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

0 vote368 views1 answer
Sql server size of every table in a db
SQL
0 vote374 views1 answer
Mysql make date from 2 column
SQL
0 vote370 views1 answer
Mysql backup certain tables workbench
SQL
0 vote375 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote352 views1 answer
Mysql grant user wildcard database
SQL
0 vote395 views1 answer
Print hello world in plsql
SQL
6 votes365 views3 answers
Date_trunc postgres
SQL
2 votes406 views2 answers
Mysql bidirectional composite primary key
SQL
2 votes392 views2 answers
How to add not null constraint in sql
SQL
0 vote392 views1 answer
Mysql update all record removing 2 hours from column
SQL