Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.53 KB | None | 0 0
  1. (SELECT
  2.         COUNT(*)
  3.     FROM Acomodacoes ac (NOLOCK)
  4.     WHERE
  5.         ac.QtdPessoas >= ((1 + (ISNULL(0,0)-0)) / 3) AND
  6.         ac.TipoAcomodacaoId = 2 AND
  7.         ac.SedeId = 3 AND
  8.         ac.Ativo = 1 AND
  9.         ((300959 = 300959 AND ac.AcomodacaoId IN (SELECT AcomodacaoId FROM fncRetornaAcomodacoesDisponiveisAtendimento('2019-05-24', '2019-05-27', 3, 2, 0))
  10.         OR
  11.         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