Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into tb_horarios(codigopersonal, dia, hora_entrada, hora_salida,
- numero_horas, malla_referencia, prd_codigo, j_codigo) select
- codigo_personal, substring(dia,1,1) AS dia, min(hora_inicio),
- MAX(hora_fin),COUNT(DISTINCT
- seccion_malla_numerohora),substring(seccion_malla_numerohora,2,1) as malla,
- 1,1
- from tb_horariodocentes_org
- where substring(seccion_malla_numerohora,1,1)='D'
- GROUP by codigo_personal,dia
- ORDER by 2,3,5
- insert into tb_horarios(codigopersonal, dia, hora_entrada, hora_salida,
- numero_horas, malla_referencia, prd_codigo) select codigo_personal,
- substring(dia,1,1) AS dia, min(hora_inicio), MAX(hora_fin),COUNT(DISTINCT
- seccion_malla_numerohora),substring(seccion_malla_numerohora,2,1) as malla,
- tb_periodo.codigo
- from tb_horariodocentes_org, tb_periodo
- where substring(seccion_malla_numerohora,1,1)='N' and
- tb_periodo.codigo='2'
- GROUP by codigo_personal,dia
- ORDER by 2,3,5
Add Comment
Please, Sign In to add comment