hegdesuchi (10/26/2016)
thank you !!This makes sense!
Well, client have a web service which inserts the values and lot of bugs with webservice and wrong value is brrn assigned to create ID. and client wants to change them to actual field .
It sounds like the right thing to do is to fix the web service to work properly. Then you won't keep accumulating bad data.
Like Jacob pointed out, make sure you have the approval of the business owners and your boss before overriding the trigger.