It seems very good solution according to the requirements you mentioned and there can be one more enhancements that is to replace trigger with Change Tracking, that will reduce the...