/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

0 vote174 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote173 views2 answers
Getting customers with no orders sql
SQL
0 vote135 views1 answer
Date diff sql
SQL
0 vote153 views1 answer
How get data from database if id not found then search another column
SQL
0 vote180 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
0 vote108 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
0 vote136 views1 answer
Psql list rules
SQL
0 vote134 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote286 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote137 views1 answer
Formatting code with SQL Developer
SQL