Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.Entidade,
- c.Nome,
- dv.Documento,
- dv.Descricao,
- YEAR(p.DataDoc) AS Ano,
- SUM(p.ValorTotal) AS ValorTotal,
- SUM(p.ValorPendente) AS ValorPendente
- FROM dbo.Pendentes p WITH(NOLOCK)
- INNER JOIN dbo.DocumentosVenda dv WITH(NOLOCK) ON p.TipoDoc = dv.Documento
- INNER JOIN dbo.Clientes c WITH(NOLOCK) ON p.Entidade = c.Cliente
- WHERE p.TipoEntidade = 'C' AND YEAR(p.DataDoc)=YEAR(GETDATE()) AND p.Entidade=20000038
- GROUP BY YEAR(p.DataDoc),
- p.Entidade,
- c.Nome,
- dv.Documento,
- dv.Descricao;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement