DELETE FROM bethadba.fomovtoserv WHERE codi_emp=9999 AND i_empregados=2 AND data='2019-02-01 00:00' AND tipo_proces=11 AND i_eventos=1 AND rateio=0 AND i_servicos=1 AND I_CALCULOS=1202 go
(...)
DELETE FROM bethadba.fobasesserv WHERE codi_emp=9999 AND i_empregados=2 AND competencia='2019-02-01 00:00' AND tipo_process=11 AND i_servicos=1 AND rateio=0 AND i_calculos=1202 go DELETE FROM bethadba.focalculos WHERE i_calculos=1202 go
DELETE FROM bethadba.FOLOG_CALCULO WHERE CODI_EMP=9999 AND I_EMPREGADOS=2 AND COMPETENCIA='2019-02-01 00:00' AND TIPO_PROCESSO=11 AND SEQUENCIAL=1 go
DELETE FIRST FROM bethadba.focalculando WHERE codi_emp=9999 AND i_empregados=2 AND usuario='GERENTE' AND connection_id=1 AND TIPO_CALCULO=1 go
Indice de Dados:
Empresa: 9999 Empregado: 2 Competencia: 01/02/2019.