Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --ITABIRITO
- SELECT ST.CODTURMA as TURMA FROM CORPORERM.dbo.SPROFESSORTURMA SP
- INNER JOIN CORPORERM.dbo.STURMADISC ST ON SP.IDTURMADISC = ST.IDTURMADISC AND SP.CODCOLIGADA = ST.CODCOLIGADA
- INNER JOIN CORPORERM.dbo.SHABILITACAOFILIAL SH ON ST.IDHABILITACAOFILIAL = SH.IDHABILITACAOFILIAL AND SH.CODCOLIGADA = ST.CODCOLIGADA
- INNER JOIN CORPORERM.dbo.SCURSO C ON C.CODCOLIGADA = ST.CODCOLIGADA AND C.CODCURSO = SH.CODCURSO
- INNER JOIN CORPORERM.dbo.SPLETIVO P ON P.IDPERLET = ST.IDPERLET AND P.CODCOLIGADA = ST.CODCOLIGADA
- 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)
- LIKE '".$curso."' and
- CODPERLET = (CAST(YEAR(GETDATE())AS VARCHAR)+'/'+CASE WHEN MONTH (GETDATE()) > 7 THEN '2' ELSE '1' END) AND CODTURMA NOT LIKE '% ED %'
- UNION
- SELECT 'TODAS AS TURMAS' AS TURMA
- ORDER BY TURMA
- --BOM DESPACHO
- SELECT ST.CODTURMA as TURMA FROM CORPORERM.dbo.SPROFESSORTURMA SP
- INNER JOIN CORPORERM.dbo.STURMADISC ST ON SP.IDTURMADISC = ST.IDTURMADISC AND SP.CODCOLIGADA = ST.CODCOLIGADA
- INNER JOIN CORPORERM.dbo.SHABILITACAOFILIAL SH ON ST.IDHABILITACAOFILIAL = SH.IDHABILITACAOFILIAL AND SH.CODCOLIGADA = ST.CODCOLIGADA
- INNER JOIN CORPORERM.dbo.SCURSO C ON C.CODCOLIGADA = ST.CODCOLIGADA AND C.CODCURSO = SH.CODCURSO
- INNER JOIN CORPORERM.dbo.SPLETIVO P ON P.IDPERLET = ST.IDPERLET AND P.CODCOLIGADA = ST.CODCOLIGADA
- WHERE C.CODCOLIGADA IN (2,1) AND ST.CODFILIAL = 1 AND CORPORERM.DBO.TiraAcentos(C.NOME)
- LIKE '".$curso."' and
- CODPERLET = (CAST(YEAR(GETDATE())AS VARCHAR)+'/'+CASE WHEN MONTH (GETDATE()) > 7 THEN '2' ELSE '1' END) AND CODTURMA NOT LIKE '% ED %'
- UNION
- SELECT 'TODAS AS TURMAS' AS TURMA
- ORDER BY TURMA
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement