>>>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).
If it's not broken, fix it until it is.
My Blog