/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 vote177 views1 answer
Sql roll up rows into columns
SQL
2 votes186 views1 answer
How to make insert script from table in SQL server
SQL
14 votes187 views3 answers
Trim sql
SQL
0 vote177 views2 answers
Oracle create chain rule
SQL
1 vote182 views1 answer
Sql server list locks
SQL
2 votes178 views2 answers
Get all tables using like
SQL
0 vote283 views1 answer
Oracle db get table sizes
SQL
0 vote173 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote186 views1 answer
Mysql a from on this page has
SQL
11 votes266 views1 answer
Oracle insert from select
SQL