Datas Aula.sql

SELECT
    CONVERT(DATE, DATA)
FROM
    (
        SELECT
            DATA = DATEADD(DAY, rn - 1, '2016-07-25')
        FROM
            (
                SELECT
                    TOP (DATEDIFF(DAY, '2016-07-25', DATEADD(DAY, (
                        SELECT
                            TOP 1
                            DATEDIFF(DD, DTINICIO, DTFIM) AS dias
                        FROM
                            SPLETIVO P
                        WHERE
                            CODTIPOCURSO = 2
                            AND P.CODPERLET = '2016/2'), '2016-07-25')))
                        rn = ROW_NUMBER()
                    OVER (
                        ORDER BY
                            s1.[object_id])
                FROM sys.all_objects AS s1
                    CROSS JOIN sys.all_objects AS s2
                ORDER BY
                    s1.[object_id]
            ) AS NUMERO_AULA
    ) AS DATA_AULA
    LEFT JOIN Corpore.dbo.GFERIADO FE ( NOLOCK )
        ON FE.DIAFERIADO = DATA_AULA.DATA
           AND FE.DIAFERIADO >= '2016-07-25'
           AND FE.CODCALENDARIO = '0000001'
WHERE
    FE.DIAFERIADO IS NULL
    AND DATEPART(WEEKDAY, DATA_AULA.DATA) > 1