Histórico da Página

SQL - Modelo

Dois modelos de SQL para serem utlizadas, mais mais simples e outra um pouco mais complexa.

Simples

SELECT DISTINCT SDISCIPLINA.CODDISC, SDISCIPLINA.NOME
FROM SMATRICULA (NOLOCK)
INNER JOIN STURMADISC (NOLOCK)
ON
SMATRICULA.CODCOLIGADA = STURMADISC.CODCOLIGADA
AND
SMATRICULA.IDPERLET = STURMADISC.IDPERLET
AND
SMATRICULA.IDTURMADISC = STURMADISC.IDTURMADISC
INNER JOIN SDISCIPLINA (NOLOCK)
ON
STURMADISC.CODCOLIGADA = SDISCIPLINA.CODCOLIGADA
AND
STURMADISC.CODDISC = SDISCIPLINA.CODDISC
INNER JOIN SPARAM (NOLOCK)
ON
SMATRICULA.CODCOLIGADA = SPARAM.CODCOLIGADA
AND
STURMADISC.CODTIPOCURSO = SPARAM.CODTIPOCURSO
AND
SMATRICULA.IDPERLET = CAST(SPARAM.TEXTO AS INT)
WHERE SPARAM.ID = 'IDPERLET'
AND
SMATRICULA.CODCOLIGADA = :CODCOLIGADA
AND
SMATRICULA.RA = :RA
AND
SMATRICULA.IDPERLET = :IDPERLET

Detalhada

SELECT DISTINCT SDISCIPLINA.CODDISC, SDISCIPLINA.NOME
FROM SHABILITACAOALUNO (NOLOCK)
INNER JOIN SHABILITACAOFILIAL (NOLOCK)
ON
SHABILITACAOALUNO.CODCOLIGADA = SHABILITACAOFILIAL.CODCOLIGADA
AND
SHABILITACAOALUNO.IDHABILITACAOFILIAL = SHABILITACAOFILIAL.IDHABILITACAOFILIAL
INNER JOIN SDISCGRADE (NOLOCK)
ON
SHABILITACAOFILIAL.CODCOLIGADA = SDISCGRADE.CODCOLIGADA
AND
SHABILITACAOFILIAL.CODCURSO = SDISCGRADE.CODCURSO
AND
SHABILITACAOFILIAL.CODHABILITACAO = SDISCGRADE.CODHABILITACAO
AND
SHABILITACAOFILIAL.CODGRADE = SDISCGRADE.CODGRADE
INNER JOIN SDISCIPLINA(NOLOCK)
ON
SDISCGRADE.CODCOLIGADA = SDISCIPLINA.CODCOLIGADA
AND
SDISCGRADE.CODDISC = SDISCIPLINA.CODDISC
INNER JOIN SMATRICULA (NOLOCK)
ON
SMATRICULA.CODCOLIGADA = SHABILITACAOFILIAL.CODCOLIGADA
AND
SMATRICULA. IDHABILITACAOFILIAL = SHABILITACAOFILIAL.IDHABILITACAOFILIAL
INNER JOIN STURMADISC (NOLOCK)
ON
SMATRICULA.CODCOLIGADA = STURMADISC.CODCOLIGADA
AND
SMATRICULA.IDPERLET = STURMADISC.IDPERLET
AND
SMATRICULA.IDTURMADISC = STURMADISC.IDTURMADISC
INNER JOIN SPARAM (NOLOCK)
ON
SMATRICULA.CODCOLIGADA = SPARAM.CODCOLIGADA
AND
STURMADISC.CODTIPOCURSO = SPARAM.CODTIPOCURSO
AND
SMATRICULA.IDPERLET = CAST(SPARAM.TEXTO AS INT)
WHERE
SPARAM.ID = 'IDPERLET' AND
SHABILITACAOALUNO.CODCOLIGADA = :CODCOLIGADA
AND
SHABILITACAOALUNO.RA = :RA
AND
SDISCGRADE.CODPERIODO <> 0
AND
SMATRICULA.CODSTATUSRES <> 1
AND
( (SHABILITACAOALUNO.IDHABILITACAOFILIAL = :IDHABILITACAOFILIAL) OR (SHABILITACAOALUNO.IDHABILITACAOFILIAL IS NULL) )