INSERT INTO sigesp_cmp (codemp, procede, comprobante, fecha, codban, ctaban, descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin)
SELECT codemp, procede, comprobante, fecha, '007', '0906-0100000208', descripcion, tipo_comp, tipo_destino, cod_pro, ced_bene, total, numpolcon, esttrfcmp, estrenfon, codfuefin
  FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011517'
   AND fecha = '2009-01-29'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE scg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011517'
   AND fecha = '2009-01-29'
   AND codban = '---'
   AND ctaban = '-------------------------';

UPDATE spg_dt_cmp 
   SET codban='007',ctaban='0906-0100000208'
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011517'
   AND fecha = '2009-01-29'
   AND codban = '---'
   AND ctaban = '-------------------------';

DELETE FROM sigesp_cmp
 WHERE codemp = '0001'
   AND procede = 'SCBBCH'
   AND comprobante = '208-00000011517'
   AND fecha = '2009-01-29'
   AND codban = '---'
   AND ctaban = '-------------------------';