/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 vote230 views1 answer
Mysql last friday of current month
SQL
0 vote202 views1 answer
Windows services sql
SQL
0 vote225 views3 answers
Join
SQL
3 votes268 views1 answer
Oracle sql commit example
SQL
9 votes219 views4 answers
SQL Date Format
SQL
1 vote192 views1 answer
Postgres set column equal to another
SQL
0 vote206 views1 answer
Sql comand for removing data from table
SQL
1 vote206 views1 answer
Oracle enable job
SQL
0 vote203 views1 answer
What is mysql_pconnect
SQL
3 votes180 views3 answers
Print in pl sql
SQL