Hi All,
i need to update a datecolumn (Original_date) based on the result from the select query. i have to create a procedure for the update statements where the params from UI will be passed. params are month_period column and Metric_Type.
i have table A will Original_date column for each metric_type and month_period . and table B is the audit colun whch will have entries for each insert,update and delete based on the table 1. now i have create a update procedure to update the Original_date of Table A based on the result of table A and table B by joining them.
Update table A
set Original_date = Original_date result of select query
where metric_type and month_period = passed from UI 2 columns (month_period column and Metric_Type).. same condition for both column..result of select query.
in case if null is passed for metric_type and month_period then it has update the original_date from column for the respective metric_type and month_period.
please help on this.