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 vote301 views1 answer
Sql server pivot rows to columns
SQL
4 votes281 views1 answer
Oracle change nls_date_format permanently
SQL
4 votes301 views4 answers
Oracle tablespace tables list
SQL
4 votes281 views2 answers
DB::transaction
SQL
5 votes262 views1 answer
Postgres upsert
SQL
0 vote274 views1 answer
Mysql events not work
SQL
8 votes288 views2 answers
Oracle auto increment primary key
SQL
1 vote318 views1 answer
Group_concat order by
SQL
0 vote240 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote296 views1 answer
Jenkins SQLCMD run
SQL