Hi Kevin. I was also paranoid about the optimizer ignoring the SELECT. I checked the locks acquired in a SQL Profiler trace and right in-between the StmtStarting and StmtCompleted of...

Hi Ken. Thanks for the suggestion. I read a nice article about a cleaner way of doing the upsert using a pattern similar to what you described. The article: