/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

1 vote327 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
17 votes361 views4 answers
Show all tables in oracle
SQL
0 vote320 views1 answer
Varchar2 length in oracle
SQL
0 vote298 views1 answer
Mysql could not fetch tables
SQL
3 votes324 views2 answers
How to delete git repo locally
SQL
0 vote242 views1 answer
Sqlalchemy existing database
SQL
0 vote307 views1 answer
Postgres read table structure
SQL
0 vote306 views1 answer
Where field is null sql knex
SQL
0 vote331 views1 answer
GROUP BY postgres
SQL
0 vote302 views1 answer
Sql server manager close connection
SQL