Skip to content

Instantly share code, notes, and snippets.

@MarioCares
Last active August 29, 2015 14:13
Show Gist options
  • Save MarioCares/254391e99a40360777a9 to your computer and use it in GitHub Desktop.
Save MarioCares/254391e99a40360777a9 to your computer and use it in GitHub Desktop.
Query SQL Migración Tabla ordencompra a Unisag
INSERT INTO finanzas_ordencompra
SELECT
orco_pk_id, orco_fk_cuclapre, orco_fk_prov, orco_fk_fo,
(CASE orco_fk_usu
WHEN "Alvaro Torres" THEN "15287582"
WHEN "Eleinne Ortíz" THEN "12566824"
WHEN "Vanessa Viza" THEN "10736574"
WHEN "Mónica Salinas" THEN "15090763"
WHEN "Mario Cares" THEN "17432116"
WHEN "Marcela Valenzuela" THEN "10534153"
WHEN "Vaneza Viza" THEN "10736574"
ELSE "10534153"
END) as orco_fk_usu,
(CASE orco_fk_estado
WHEN 8 THEN 5
WHEN 7 THEN 4
WHEN 6 THEN 3
ELSE orco_fk_estado
END) as orco_fk_estado,
orco_fecha, 19, 0,
orco_descripcion, "Observacion", orco_destino, "Solicitante",
concat(orco_numero,"/",year(orco_fecha)), orco_total, "SALUD"
FROM saludcor_adquisiciones.ordencompra order by orco_fk_estado DESC limit 10000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment