/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 vote334 views1 answer
Syntax for changing column size in mysql
SQL
0 vote356 views2 answers
Default constraint in ms sql
SQL
0 vote322 views1 answer
Soql more than today
SQL
0 vote340 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote329 views1 answer
Sql server inner join convert collation
SQL
0 vote372 views1 answer
Sql query wordpress export post
SQL
1 vote345 views1 answer
Postgresql round double precision
SQL
0 vote350 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
2 votes285 views1 answer
Sql view column data type
SQL
0 vote329 views1 answer
How to query all tables mysql at the same time
SQL