ChrisM@Work (1/30/2014)
MERGE #temp TIs the table #temp always empty before you start the upsert?
No it will not empty..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/