Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Department revenue pivot
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' SELECT department, SUM(CASE WHEN MONTH='Jan' THEN revenue ELSE 0 END) AS Jan_Revenue, SUM(CASE WHEN MONTH='Feb' THEN revenue ELSE 0 END) AS Feb_Revenue, ... FROM department GROUP BY department ORDER BY department
run
|
edit
|
history
|
help
0
Running Total
a
Rextester implements OUTPUT feature of Update ~ Delete (2016 >)
My data
Consecutive publisher publish more than 2 books for 3 days
for xml path concatenation ordered by seqno
1
PIVOT AND UNPIVOT USING XML PARSING
database size
BC160401693