Hi Akshay,

I just wrote an example of the usage of the Merge command in this post

I think the T-SQL merge command is a powerful option.

If you have any question I could explain you a little bit more.

Kind Regards.