/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

2 votes114 views1 answer
Ifnull postgres
SQL
0 vote144 views1 answer
Creating h2 database in relative directory eclopse
SQL
2 votes114 views2 answers
Get all columns from table sql
SQL
0 vote128 views1 answer
Apt install sql server
SQL
1 vote135 views1 answer
SQLSTATE[HY000] [2002]
SQL
6 votes142 views2 answers
Sql sequence
SQL
0 vote143 views2 answers
What is rownum in oracle
SQL
0 vote127 views1 answer
Wp_query raw sql
SQL
15 votes139 views4 answers
Pl sql
SQL
0 vote134 views1 answer
How to delete python anywhere mysql database
SQL