Guest User

Untitled

a guest
Sep 18th, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. PLACE DATE_OPEN SUM
  2. -----------------------
  3. PLACE1 03.09.2018 2
  4. PLACE2 03.09.2018 2
  5. PLACE1 04.09.2018 8
  6. PLACE1 05.09.2018 9
  7. PLACE2 05.09.2018 1
  8.  
  9. SELECT
  10. SB AS [PLACE],
  11. CAST(OPEN_TIME AS DATE) AS [DATE_OPEN],
  12. COUNT(ID) AS [SUM]
  13. FROM
  14. [Table]
  15. WHERE
  16. SB IN ('PLACE1', 'PLACE2')
  17. GROUP BY
  18. SB, CAST(OPEN_TIME AS DATE)
  19.  
  20. PLACE DATE_OPEN
  21. 03.09.2018 04.09.2018 05.09.2018
  22. PLACE1 2 8 9
  23. PLACE2 2 1
  24.  
  25. WITH Demo AS
  26. (
  27. SELECT * FROM (VALUES
  28. ('PLACE1', '03.09.2018', 2),
  29. ('PLACE2', '03.09.2018', 2),
  30. ('PLACE1', '04.09.2018', 8),
  31. ('PLACE1', '05.09.2018', 9),
  32. ('PLACE2', '05.09.2018', 1)) T(PLACE, DATE_OPEN, [SUM])
  33. )
  34. SELECT * FROM Demo
  35. PIVOT (SUM([Sum]) FOR Date_Open IN ([03.09.2018],[04.09.2018],[05.09.2018])) P
  36.  
  37. PLACE 03.09.2018 04.09.2018 05.09.2018
  38. ------ ----------- ----------- -----------
  39. PLACE1 2 8 9
  40. PLACE2 2 NULL 1
Add Comment
Please, Sign In to add comment