Advertisement
Guest User

Untitled

a guest
Jan 26th, 2015
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. insert into finanzas_otro_documento_egreso
  2. select pag_pk_id, pag_fk_cuclapre, pag_fk_fo, '10534153' as usuario_id, pag_fk_memo, pag_fecha, 'usuario', pag_total, pag_fecha, pag_detalle,
  3. "SALUD", tieg_descripcion
  4. from saludcor_adquisiciones.pago inner join saludcor_adquisiciones.tipoegreso on tipoegreso.tieg_pk_id = pago.pag_fk_tieg
  5. where pag_fk_tieg in (10, 9, 8, 7, 6, 5, 4) and year(pag_fecha) = 2014 and month(pag_fecha) != 12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement