Are you sure? If so, what's the use of Begin...End Trans? Nothing. Why using it where there is no way restoring the original values of the source table? Based on what you are saying that the values to be restored are the values of the Views not of the Source, it's useless.