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 vote113 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote112 views1 answer
Oracle search columns in schema
SQL
12 votes124 views4 answers
Import mysql database command line linux
SQL
0 vote117 views1 answer
Sql select column name like from multiple tables
SQL
0 vote74 views1 answer
Calculate discount from original price sql
SQL
0 vote123 views1 answer
Check database restore status sql script
SQL
1 vote120 views1 answer
Show structure of table in sql
SQL
0 vote118 views1 answer
Mysql config address
SQL
-1 vote85 views1 answer
Mysql if example
SQL
0 vote111 views2 answers
Imageview setimageresource null
SQL