/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

14 votes191 views2 answers
Oracle add attribute to table
SQL
1 vote182 views1 answer
SQL query to get all table records count from a database
SQL
5 votes181 views1 answer
Oracle list functions
SQL
6 votes165 views1 answer
Phpmyadmin reset root password
SQL
0 vote190 views1 answer
Sql server sleep
SQL
5 votes164 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote194 views1 answer
Insert value in identity
SQL
5 votes187 views2 answers
Sql server check port number
SQL
1 vote172 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote198 views1 answer
Automated psql csv export script on windows
SQL