INSERT INTO bethadba.focalculando(codi_emp,i_empregados,usuario,connection_id, TIPO_CALCULO) VALUES (9999,4,'GERENTE',1,1) go --DELETE-1001-04683672656 DELETE FROM bethadba.forescisoes WHERE codi_emp=9999 AND i_empregados=4 AND tipo=2 AND I_CALCULOS=1187 go --DELETE-1001-04683675036 DELETE FROM bethadba.fomovtoserv WHERE codi_emp=9999 AND i_empregados=4 AND data='2019-01-01 00:00' AND tipo_proces=42 AND i_eventos=876 AND rateio=0 AND i_servicos=1 AND I_CALCULOS=1187 go
(...)
DELETE FROM bethadba.fobasesserv WHERE codi_emp=9999 AND i_empregados=4 AND competencia='2019-01-01 00:00' AND tipo_process=42 AND i_servicos=1 AND rateio=0 AND i_calculos=1187 go
DELETE FROM bethadba.FOLOG_CALCULO WHERE CODI_EMP=9999 AND I_EMPREGADOS=4 AND COMPETENCIA='2019-01-01 00:00' AND TIPO_PROCESSO=42 AND SEQUENCIAL=1 go
Índice:
Empresa: 9999 Empregado: 4 Competência: 01/01/2019