Thank you guys for your reply...

I did use DBCC to check the table...it did not change anything...

The bad data was generated by value divided by zero...By the time, we found...

Thank you guys for your kindly help.

I have solved the problem. Just for in case,anyone wants to know. Here is what I did.

1. add new column to the table

2. copy...

Thanks Andy!

But if that is the case, what should I do to solve it? Any suggestion?

Thank you guys!

I can understand that we should keep Scan Count and Logical Reads as low as possible. But When you come to the point where you have to choose...