• Neddy,

    You state:

    Another table is inserting into the table with Status_Date bya trigger

    Check out the trigger, it might be the cause of your problem.

    -SQLBill