Here you go I updated your code to reflect some of the suggestions

set nocount on

--Cleanup

if exists (select * from tempdb.sys.tables where name like '#SearchResult%') drop table #SearchResult

if...

Also to make provisions for Databases,schemas,Tables and fields names that have spaces by adding "[" and "]" to the strings

Hi Gaurav,

another suggestion is that you add a variable for schema as I see you assume that all tables will be in a "dbo" schema

+1 Good Question thought I had it but I was wrong, been using the MERGE statement alot these days but never with Tables having INSTEAD OF triggers

You learn something new...