/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 vote169 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
8 votes148 views2 answers
Select table column name in sql
SQL
0 vote185 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote119 views1 answer
Mysql insert with foreign key
SQL
0 vote166 views1 answer
Python dictionary to sql update
SQL
2 votes179 views1 answer
Oracle trace file
SQL
0 vote210 views1 answer
How to connect to xampp sql server on windows cmd
SQL
2 votes191 views1 answer
Select a certain number of entries from select mysql
SQL
4 votes171 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
36 votes171 views3 answers
Add column in mysq
SQL