>>>>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.
>
>There would not be any delay. 2000 records is nothing for SQL Server (assuming you have indexes for all PK/FK columns).
I will try and see.
"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