Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Qtde Data
- 5000 18-07-2017
- 5001 18-07-2017
- 5002 25-07-2017
- SELECT DISTINCT
- S.SolID AS [Qtde - Chamados em Pausa],
- MAX(CONVERT(DATE,T.TraData,103))
- FROM Solicitacao S
- LEFT JOIN Usuario U ON U.UsuID = S.UsuIDResponsavel
- LEFT JOIN Tramite T ON T.SolID = S.SolID
- WHERE S.VencimentoPausado = 1 AND
- T.TraData < DATEDIFF ( DAY ,2, getdate())
- group by s.SolID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement