Hi!! We can easily work on your requirement. It can be managed by differnt ways - trigger, sql jobs, stored procedure, etc. However, i like to review the requirement in more details. I am available for any further discussion.
I am waiting for final feedback.