/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

3 votes153 views1 answer
Export postgres database linux
SQL
8 votes91 views1 answer
Oracle current date plus 1 month
SQL
0 vote140 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote83 views1 answer
Mysql find foreign key references
SQL
0 vote129 views1 answer
Sqlite3 get data from table c
SQL
0 vote121 views1 answer
Run mssql server terminal
SQL
0 vote113 views1 answer
Oracle DROP PROGRAM
SQL
0 vote118 views1 answer
Oracle sql log to console
SQL
0 vote127 views1 answer
Search mysql database for column
SQL
2 votes122 views3 answers
Write sql query to find the second highest salary of employee
SQL