/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

4 votes252 views2 answers
How to insert ip address in mysql using php
SQL
0 vote267 views3 answers
CONTACT FORM SQL
SQL
4 votes256 views1 answer
Change nls_date_format
SQL
5 votes278 views3 answers
Show indexes mysql
SQL
0 vote249 views1 answer
Mysql pv progres
SQL
3 votes258 views1 answer
Dbms_scheduler drop_job
SQL
2 votes262 views1 answer
Mysql clear screen
SQL
0 vote288 views1 answer
Get role postgres
SQL
0 vote256 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
2 votes265 views2 answers
Sql percentage
SQL