I would like to update TASK_NXT_RUN_DT column based on the script in column 2 dynamically. I have tried using while loop and dynamic sql but no luck. Any help on this much appreciated
create table #CFG_PROCESS_EVALUATE_TASK_MSTR (
insert into #CFG_PROCESS_EVALUATE_TASK_MSTR
select 1,'dateadd(dd,1,TASK_NXT_RUN_DT)','2020-04-02 03:17:40.043', '2020-04-02 03:17:24.353' union all
select 2,'dateadd(dd,10,TASK_NXT_RUN_DT)' ,'2020-04-02 03:17:40.043', '2020-04-02 03:17:24.353'