Guest User

Untitled

a guest
Apr 24th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. SELECT
  2. R.INDICE,
  3. R.ID,
  4. R.NUM,
  5. R.MONTO,
  6. R.SALDO,
  7. SUM(
  8. D.MONTO *
  9. CASE
  10. WHEN D.NUM=2 THEN -1
  11. ELSE 1
  12. END
  13. ) [SALDO]
  14.  
  15. SELECT *
  16. FROM dbo.TuTabla A
  17. OUTER APPLY (SELECT SUM(CASE WHEN NUM = 2 THEN -1 ELSE 1 END * MONTO) SALDO
  18. FROM dbo.TuTabla
  19. WHERE ID = A.ID
  20. AND INDICE <= A.INDICE) B
  21. ;
  22.  
  23. ╔════════╦════╦═════╦═══════╦═══════╗
  24. ║ INDICE ║ ID ║ NUM ║ MONTO ║ SALDO ║
  25. ╠════════╬════╬═════╬═══════╬═══════╣
  26. ║ 4 ║ 4 ║ 1 ║ 100 ║ 100 ║
  27. ║ 5 ║ 4 ║ 2 ║ 0 ║ 100 ║
  28. ║ 6 ║ 4 ║ 2 ║ 100 ║ 0 ║
  29. ║ 7 ║ 4 ║ 1 ║ 100 ║ 100 ║
  30. ║ 8 ║ 4 ║ 1 ║ 200 ║ 300 ║
  31. ║ 9 ║ 4 ║ 2 ║ 1000 ║ -700 ║
  32. ╚════════╩════╩═════╩═══════╩═══════╝
Add Comment
Please, Sign In to add comment