Does the merge statement need the HOLDLOCK hint?

[coderdnewbie]

trafficstars

I have seen other solutions use the ‘WITH (HOLDLOCK)‘ hint when generating the merge statement.

Is this hint missing from your solution?

See https://weblogs.sqlteam.com/dang/2009/01/31/upsert-race-condition-with-merge/

Also, do you drop the temporary table when you are finished with it as I could not see this code.