SET MyTable.TransactionErrors = 0
WHERE MyTable.TransactionErrors >= 10
This will be a permanent change to the column on which it is applied, so the values will all be reset to 0 and the previous values will be lost. Is that what you want?
This will not present any data, just change the underlying data in the table.
Look it up at: http://wrox.books24x7.com