Hi... I have two tables Child table and Master table Child table contans morethan twenty Datetime columns where i am currently storing Actual dateTime values. and Master table contains DateID which is autogenerated and DateValue(contains Actual dateTime value) columns.
Now My requirement is I have to update child table's all DateTime Columns ActualData(dateTime) with DateID column data(Master table ID). What is the best way to update.? TIA.