Lempster (12/10/2013)
Can you not even be bothered to type "TSQL MERGE" into your favourite search engine? Jeez...
Which, or how many, of the 297000 returns that Google brings back would you suggest the OP read??
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service