/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 vote295 views1 answer
Add alternate add column sql
SQL
0 vote278 views1 answer
Sql runnignsum
SQL
0 vote331 views1 answer
Mysql limit order by
SQL
2 votes309 views2 answers
How to check data type in sql server
SQL
0 vote304 views1 answer
Mysql disable query caching
SQL
0 vote300 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
2 votes302 views1 answer
No data found oracle
SQL
0 vote314 views1 answer
Update and keep original value sql
SQL
5 votes305 views1 answer
How to check nls format in oracle
SQL
0 vote320 views2 answers
Drop tables from local table database postgres
SQL