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