Diferencia entre revisiones de «BLOQUEO DE SALARIO POR TENER CUIL EN BLANCO»
De Wiki
Línea 3: | Línea 3: | ||
select * from DH02 where sino_cargo='N' and (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil='' | select * from DH02 where sino_cargo='N' and (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil='' | ||
− | update "DH02" set SINO_FLIARACARGO=0,sino_cargo='N' where (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil='' | + | update "DH02" set SINO_FLIARACARGO=0,sino_cargo='N' where (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil='' and (SINO_FLIARACARGO=1 or sino_cargo='S') |
Revisión actual del 12:51 13 dic 2012
select * from DH02 where SINO_FLIARACARGO=1 and (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil=
select * from DH02 where sino_cargo='N' and (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil=
update "DH02" set SINO_FLIARACARGO=0,sino_cargo='N' where (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil= and (SINO_FLIARACARGO=1 or sino_cargo='S')