>>Thank you. This will be a challenge for me to create such a stored procedure. I am sure it is not that complicated but I have created only very simple stored procedures. But maybe it is time to learn.
>>
>
>If the re-calculation algorithm is simple enough, I suggest to go with James' suggestion.
I started thinking about implementing the stored procedure and realized that the entire thing would be a rather long SQL UPDATE command. The downside of it is I cannot show a real time progress to the user (like Record by Record progress) but rather just one message saying "Please wait while... whatever". But the first thing is I will see if I can create such Update command.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham