/SQL/Get count by weekly pivot table sql server

Get count by weekly pivot table sql server

  SELECT Depots.Name AS 'Depot',  Account.Name, '22/01/2012',  '29/01/2012',  '05/02/2012',  '12/02/2012',
   FROM 
(SELECT Name, 
    FROM Deliveries
    INNER JOIN Account ON Deliveries.Customer = Account.ID
    INNER JOIN Depots ON Account.CollectionDepot) AS Source
PIVOT
(
    SUM(Deliveries.Rates)
    FOR Date IN ('22/01/2012',  '29/01/2012',  '05/02/2012',  '12/02/2012')
) AS 'Pivot Table'

Source: stackoverflow.com

Similar codes

8 votes199 views3 answers
Find table for column name in sql
SQL
0 vote194 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote174 views1 answer
Narural join
SQL
1 vote196 views1 answer
Hackerrank sql test solutions
SQL
0 vote187 views1 answer
Oracle last connexion
SQL
0 vote176 views1 answer
Top 3 salary in sql
SQL
0 vote179 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
10 votes177 views3 answers
How to fetch first 5 characters in sql
SQL
12 votes254 views4 answers
How to drop all tables in postgresql
SQL
8 votes162 views1 answer
Oracle add months to sysdate
SQL