/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 vote214 views1 answer
Ssms connect with connection string
SQL
3 votes222 views1 answer
Pl sql escape &
SQL
11 votes223 views2 answers
Having in sql
SQL
2 votes210 views2 answers
Mysql limit
SQL
0 vote209 views1 answer
Get server date mysql
SQL
8 votes219 views1 answer
Today minus 15 days postgresql
SQL
0 vote221 views1 answer
Mysql pad zeros
SQL
0 vote215 views1 answer
Oracle running queries sql
SQL
0 vote220 views1 answer
Oracle sql number to varchar2
SQL
0 vote227 views1 answer
Procedures sql insert mysql
SQL