I am using SQL Server 2005 as back end and asp.net as front end. In my project i have a critical issue. i will explain this issue as brief .
I have a table in sql, the table have three coulmn. one for amount ,one for a status flag and one primary key. during the initial transaction of a day the first insertion will occur, that is ok. At the end of the day the approval autority approve the transaction with a new updated amount and a new approval flag. Sometimes this amount or flag will lose. This will occur very rare in a year, but this issue is very critical, it will stop the next day works.
This is my issue, any one face this type of problem and any one know the reason for this type of updation missing problem, then inform me.