Script de Pervasive para agregar vinculos de cargos en Pampa

De Wiki
Saltar a: navegación, buscar
  • Consulto

SELECT nro_legaj,nro_cargo FROM "DH03" where codc_uacad='95' and nro_cargo not in (select nro_cargo from dh10)

  • Actualizo

insert into dh10 (SELECT nro_cargo,nro_cargo,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 FROM "DH03" where codc_uacad='95' and nro_cargo not in (select nro_cargo from dh10))

Obtenido de «http://mapuche.sae.unc.edu.ar/wiki/index.php?title=Script_de_Pervasive_para_agregar_vinculos_de_cargos_en_Pampa&oldid=3743»