Hi Thanks for your conern..yes it is sql server 2008R2 but i never work with merge statements.

Could you please help me.

Thanks in Advance.