Chirs, I can use IF EXISTS but as it will perform row by row so when there is bulk data arounds 5-10 lakhs that my procedure will take long time to execute and it will hit performance thats why I choose MERGE....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/