Advertisement
Guest User

Untitled

a guest
Jul 25th, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Qtde Data
  2. 5000 18-07-2017
  3. 5001 18-07-2017
  4. 5002 25-07-2017
  5.  
  6. SELECT DISTINCT
  7. S.SolID AS [Qtde - Chamados em Pausa],
  8. MAX(CONVERT(DATE,T.TraData,103))
  9. FROM Solicitacao S
  10. LEFT JOIN Usuario U ON U.UsuID = S.UsuIDResponsavel
  11. LEFT JOIN Tramite T ON T.SolID = S.SolID
  12. WHERE S.VencimentoPausado = 1 AND
  13. T.TraData < DATEDIFF ( DAY ,2, getdate())
  14. group by s.SolID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement