Page Comparison

-- Inicializa variables
SET @i_nivel_id = 0;

-- Obtiene información de EstadoGrado
select n.nivel_id into @i_nivel_id
from nivel as n
where n.pais_id = @i_pais_id -- utilizar variable de país o pais_id
and n.nivel_clave = '001';

INSERT INTO grado (nivel_id, grado_clave, grado, grado_orden, activo, fecha_actualizacion, persona_rol_id, version)
SELECT @i_nivel_id as nivel_id,
'3EI' as grado_clave,
'Pre-Jardín' as grado,
100 as grado_orden,
1 as activo,
now() as fecha_actualizacion,
@i_persona_rol_id as persona_rol_id,
0 as version
from grado
where grado_id = 0
and '3EI' not in (select grado_clave from grado where nivel_id = @i_nivel_id)
and 'Pre-Jardín' not in (select grado from grado where nivel_id = @i_nivel_id);