SQL - consulta tabla empleados

WITH ConsultaRecursiva AS

    (SELECT IdEnlace,

            texto_entrada,

            fk_entradapadre,

            orden,

            orden AS ordenpadre

        FROM Enlace_Menu AS PADRE

        WHERE fk_menu = 3 AND fk_entradapadre IS NULL

    UNION ALL

     SELECT HIJO.IdEnlace,

            HIJO.texto_entrada,

            HIJO.fk_entradapadre,

            HIJO.orden,

            CR.orden AS ordenpadre

    FROM Enlace_Menu AS HIJO

    INNER JOIN ConsultaRecursiva AS CR ON CR.pk_serie = HIJO.fk_entradapadre)

    SELECT DISTINCT

            CR1.IdEnlace,

            CR1.texto_entrada,

            CR1.fk_entradapadre,

            CR1.orden,

            CR1.ordenpadre

    FROM ConsultaRecursiva AS CR1

    ORDER BY CR1.ordenpadre, CR1.orden