/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

7 votes291 views2 answers
Mysql default value
SQL
1 vote285 views1 answer
Oracle split string
SQL
0 vote273 views1 answer
Mysql auto increment default value with prefix month and year
SQL
3 votes292 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
9 votes305 views1 answer
No sql
SQL
0 vote317 views1 answer
GROUP BY postgres
SQL
-2 votes283 views1 answer
Mysql see users and passwords
SQL
8 votes324 views2 answers
Update sql server from another table
SQL
2 votes315 views1 answer
Sqlplus clear screen
SQL
0 vote237 views0 answer
How to connect to datbase in springboot
SQL