/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 vote321 views2 answers
What is rownum in oracle
SQL
0 vote303 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote279 views1 answer
Oracle job class
SQL
0 vote276 views1 answer
IS THEre any difference between using default and := in plsql
SQL
4 votes294 views1 answer
Find tables with column name in sql
SQL
2 votes287 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote286 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote289 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote228 views1 answer
Sqlalchemy existing database
SQL
0 vote292 views2 answers
Default constraint in ms sql
SQL