Advertisement
42ama

allSqrsFill

Mar 25th, 2020
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. WITH
  2. sqrsFill
  3. AS
  4. (
  5. SELECT B_Q_ID, [R], [G], [B]
  6. FROM
  7. (
  8. SELECT B_Q_ID, V_COLOR, B_VOL
  9. FROM utB utB
  10. JOIN utV utV ON utB.B_V_ID = utV.V_ID
  11. ) t
  12. PIVOT
  13. (
  14. SUM(B_VOL)
  15. FOR V_COLOR IN ([R], [G], [B])
  16. ) pv
  17. ),
  18. allSqrsFill
  19. AS
  20. (
  21. SELECT B_Q_ID,
  22. ISNULL(R, 0) AS R,
  23. ISNULL(G, 0) AS G,
  24. ISNULL(B, 0) AS B
  25. FROM sqrsFill
  26. UNION
  27. SELECT Q_ID, 0, 0, 0
  28. FROM utQ
  29. WHERE Q_ID NOT IN
  30. (
  31. SELECT B_Q_ID
  32. FROM sqrsFill
  33. )
  34. )
  35. SELECT *
  36. FROM allSqrsFill
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement