salix/db/versions/10862-navyHydrangea/03-updateExpense.sql

UPDATE vn.expense
SET id = CASE id
    WHEN 7000010000 THEN 7001001000
    WHEN 7000020000 THEN 7001002000
    WHEN 7000030000 THEN 7001003000
    WHEN 7000040000 THEN 7001004000
    WHEN 7000050000 THEN 7001005000
    WHEN 7000060000 THEN 7001006000
    WHEN 7000070000 THEN 7001007000
    WHEN 7002060000 THEN 7001206000
    WHEN 7002070000 THEN 7001207000
    WHEN 7002030000 THEN 7001203000
    WHEN 7002040000 THEN 7001204000
    WHEN 7002050000 THEN 7001205000
    WHEN 7002020000 THEN 7001202000
    WHEN 7002010000 THEN 7001201000
    WHEN 7001060000 THEN 7001106000
    WHEN 7001070000 THEN 7001107000
    WHEN 7001030000 THEN 7001103000
    WHEN 7001040000 THEN 7001104000
    WHEN 7001050000 THEN 7001105000
    WHEN 7001020000 THEN 7001102000
    WHEN 7001010000 THEN 7001101000
    WHEN 7000080000 THEN 7040008000
    WHEN 7001080000 THEN 7000108000
    WHEN 7002080000 THEN 7001208000
    WHEN 7000090000 THEN 7001009000
    WHEN 7002090000 THEN 7001209000
    WHEN 7002100000 THEN 7001210000
    WHEN 7001090000 THEN 7001109000
    WHEN 7001100000 THEN 7001110000
    WHEN 7000120000 THEN 7001012000
    WHEN 7002120000 THEN 7001212000
    WHEN 7000130000 THEN 7001013000
    WHEN 7000140000 THEN 7001014000
    ELSE id
END
WHERE id IN (7000010000, 7000020000, 7000030000, 7000040000, 7000050000,
             7000060000, 7000070000, 7002060000, 7002070000, 7002030000,
             7002040000, 7002050000, 7002020000, 7002010000, 7001060000,
             7001070000, 7001030000, 7001040000, 7001050000, 7001020000,
			7001010000, 7000080000, 7001080000, 7002080000, 7000090000,
			7002090000, 7002100000, 7001090000, 7001100000,
			7000120000, 7002120000, 7000130000, 7000140000);