Advertisement
Pionez

Untitled

May 6th, 2020
1,454
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.58 KB | None | 0 0
  1. SELECT p.Entidade,
  2.        c.Nome,
  3.        dv.Documento,
  4.        dv.Descricao,
  5.        YEAR(p.DataDoc) AS Ano,
  6.        SUM(p.ValorTotal) AS ValorTotal,
  7.        SUM(p.ValorPendente) AS ValorPendente
  8. FROM dbo.Pendentes p WITH(NOLOCK)
  9.      INNER JOIN dbo.DocumentosVenda dv WITH(NOLOCK) ON p.TipoDoc = dv.Documento
  10.      INNER JOIN dbo.Clientes c WITH(NOLOCK) ON p.Entidade = c.Cliente
  11. WHERE p.TipoEntidade = 'C' AND YEAR(p.DataDoc)=YEAR(GETDATE()) AND p.Entidade=20000038
  12. GROUP BY YEAR(p.DataDoc),
  13.          p.Entidade,
  14.          c.Nome,
  15.          dv.Documento,
  16.          dv.Descricao;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement