/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

3 votes180 views1 answer
System.debug apex
SQL
0 vote222 views1 answer
SQL check if record exist
SQL
0 vote198 views1 answer
Migrations.RunSQL
SQL
24 votes178 views5 answers
Sql reset auto increment
SQL
0 vote199 views1 answer
Stored function in sql
SQL
0 vote222 views1 answer
Gcloud sql list databases
SQL
1 vote205 views2 answers
Extract weekday from date in sql
SQL
9 votes221 views3 answers
Date format in sql
SQL
5 votes191 views2 answers
To date oracle
SQL
0 vote191 views1 answer
Get id if is not equal in certain table
SQL