Diferencia entre revisiones de «BLOQUEO DE SALARIO POR TENER CUIL EN BLANCO»
De Wiki
(Página nueva: update "DH02" set SINO_FLIARACARGO=0,sino_cargo='N' where (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil='') |
|||
| Línea 1: | Línea 1: | ||
| + | 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='' | update "DH02" set SINO_FLIARACARGO=0,sino_cargo='N' where (codc_paren='HIJO' or codc_paren='MENO' or codc_paren='PREN') and cuil='' | ||
Revisión 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=
