Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2015
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1. --ITABIRITO
  2. SELECT ST.CODTURMA as TURMA FROM CORPORERM.dbo.SPROFESSORTURMA SP
  3. INNER JOIN CORPORERM.dbo.STURMADISC ST ON SP.IDTURMADISC = ST.IDTURMADISC AND SP.CODCOLIGADA = ST.CODCOLIGADA
  4. INNER JOIN CORPORERM.dbo.SHABILITACAOFILIAL SH ON ST.IDHABILITACAOFILIAL = SH.IDHABILITACAOFILIAL AND SH.CODCOLIGADA = ST.CODCOLIGADA
  5. INNER JOIN CORPORERM.dbo.SCURSO C ON C.CODCOLIGADA = ST.CODCOLIGADA AND C.CODCURSO = SH.CODCURSO
  6. INNER JOIN CORPORERM.dbo.SPLETIVO P ON P.IDPERLET = ST.IDPERLET AND P.CODCOLIGADA = ST.CODCOLIGADA
  7. WHERE C.CODCOLIGADA IN (2,5,10) AND ST.CODFILIAL = CASE WHEN C.CODCOLIGADA =2 THEN 5 ELSE 1 END AND CORPORERM.DBO.TiraAcentos(C.NOME)
  8. LIKE '".$curso."' and
  9. CODPERLET = (CAST(YEAR(GETDATE())AS VARCHAR)+'/'+CASE WHEN MONTH (GETDATE()) > 7 THEN '2' ELSE '1' END) AND CODTURMA NOT LIKE '% ED %'
  10. UNION
  11. SELECT 'TODAS AS TURMAS' AS TURMA
  12. ORDER BY TURMA
  13.  
  14.  
  15. --BOM DESPACHO
  16. SELECT ST.CODTURMA as TURMA FROM CORPORERM.dbo.SPROFESSORTURMA SP
  17. INNER JOIN CORPORERM.dbo.STURMADISC ST ON SP.IDTURMADISC = ST.IDTURMADISC AND SP.CODCOLIGADA = ST.CODCOLIGADA
  18. INNER JOIN CORPORERM.dbo.SHABILITACAOFILIAL SH ON ST.IDHABILITACAOFILIAL = SH.IDHABILITACAOFILIAL AND SH.CODCOLIGADA = ST.CODCOLIGADA
  19. INNER JOIN CORPORERM.dbo.SCURSO C ON C.CODCOLIGADA = ST.CODCOLIGADA AND C.CODCURSO = SH.CODCURSO
  20. INNER JOIN CORPORERM.dbo.SPLETIVO P ON P.IDPERLET = ST.IDPERLET AND P.CODCOLIGADA = ST.CODCOLIGADA
  21. WHERE C.CODCOLIGADA IN (2,1) AND ST.CODFILIAL = 1 AND CORPORERM.DBO.TiraAcentos(C.NOME)
  22. LIKE '".$curso."' and
  23. CODPERLET = (CAST(YEAR(GETDATE())AS VARCHAR)+'/'+CASE WHEN MONTH (GETDATE()) > 7 THEN '2' ELSE '1' END) AND CODTURMA NOT LIKE '% ED %'
  24. UNION
  25. SELECT 'TODAS AS TURMAS' AS TURMA
  26. ORDER BY TURMA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement