Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (SELECT
- COUNT(*)
- FROM Acomodacoes ac (NOLOCK)
- WHERE
- ac.QtdPessoas >= ((1 + (ISNULL(0,0)-0)) / 3) AND
- ac.TipoAcomodacaoId = 2 AND
- ac.SedeId = 3 AND
- ac.Ativo = 1 AND
- ((300959 = 300959 AND ac.AcomodacaoId IN (SELECT AcomodacaoId FROM fncRetornaAcomodacoesDisponiveisAtendimento('2019-05-24', '2019-05-27', 3, 2, 0))
- OR
- 300959 <> 300959 AND ac.AcomodacaoId IN (SELECT AcomodacaoId FROM fncRetornaAcomodacoesDisponiveis('2019-05-24', '2019-05-27', 3, 2, 0))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement