Hi,
I have a table with 33 columns, in which 6 columns data will get updated depending on the values of other 27 columns.
Even few column values are interdependent.
Example : One of the Six columns value is input for second column of six columns.
I have maintained the sequence also.
I have created six user defined functions to update these 6 columns in sequence.
When I run the Update Query all the columns are not getting updated at a time. I have to run the updatequery six times
to get all the six columns to be updated.
The user defined functions are having minimum 3 and max 5 parameters.
I dont know what precautions to be taken while creating an update query.
Please guide
Thank you.