Advertisement
Guest User

Entradas com valores negativos

a guest
Jul 24th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. SELECT  Categoria, TipoDoc, Ano, Mes, Valor, TipoMov
  2. FROM (
  3. SELECT '0. Bancos' AS Categoria,movim AS tipodoc,YEAR(DtMov) AS Ano, MONTH(DtMov) AS Mes,
  4. (CASE WHEN TipoMov = 'C' THEN -(Round(SUM(Valor),2)) WHEN TipoMov = 'D' THEN (Round(SUM(Valor),2)) ELSE (Round(SUM(Valor),2)) END) AS Valor,
  5.  (CASE WHEN TipoMov = 'C' THEN 'Entradas' WHEN TipoMov = 'D' THEN 'Saídas'ELSE TipoMov END) AS TipoMov
  6. FROM MovimentosBancos
  7. WHERE
  8.  Movim = Movim AND MONTH(DtMov) IN (1,2,3,4,5,6,7,8,9,10,11,12)
  9. GROUP BY Movim, MONTH(DtMov), YEAR(DtMov), TipoMov
  10. )AS det
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement