update que utiliza o case when

update_phoda.sql

update movfinanceiro set dtPagto = case 
when movfinanceiro.idfinanceiro >201 and movfinanceiro.idfinanceiro < 259 then '2019-01-10 00:00:00'
when movfinanceiro.idfinanceiro >258 and movfinanceiro.idfinanceiro <319 then '2019-02-10 00:00:00'
when movfinanceiro.idfinanceiro >319 and movfinanceiro.idfinanceiro <378 then '2019-03-10 00:00:00'
when movfinanceiro.idfinanceiro >377 and movfinanceiro.idfinanceiro <437 then '2019-04-10 00:00:00'
when movfinanceiro.idfinanceiro >436 and movfinanceiro.idfinanceiro <496 then '2019-05-10 00:00:00'
when movfinanceiro.idfinanceiro >495 and movfinanceiro.idfinanceiro <555 then '2019-06-10 00:00:00'
when movfinanceiro.idfinanceiro >554 and movfinanceiro.idfinanceiro <614 then '2019-07-10 00:00:00'
when movfinanceiro.idfinanceiro >613 and movfinanceiro.idfinanceiro <673 then '2019-08-10 00:00:00'
when movfinanceiro.idfinanceiro >772 and movfinanceiro.idfinanceiro <732 then '2019-09-10 00:00:00'
when movfinanceiro.idfinanceiro >731 and movfinanceiro.idfinanceiro <791 then '2019-10-10 00:00:00'
when movfinanceiro.idfinanceiro >790 and movfinanceiro.idfinanceiro <850 then '2019-11-10 00:00:00'
when movfinanceiro.idfinanceiro >849 and movfinanceiro.idfinanceiro <909 then '2019-12-10 00:00:00'
end where vlpago is not null;