/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 votes293 views2 answers
Join update query in sql
SQL
0 vote336 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
-2 votes298 views3 answers
Sqlite reset autoincrement
SQL
24 votes312 views6 answers
Rename a column in sql server
SQL
-1 vote294 views1 answer
Sql getdate date only
SQL
0 vote332 views1 answer
Insert into table with only identity column
SQL
0 vote295 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote290 views1 answer
Minecraft duping allowed servers
SQL
1 vote315 views1 answer
Pl sql insert into table
SQL
0 vote304 views1 answer
List all functions and procedures in postgres query
SQL