Very nice article - Thanks!
I'm especially glad to see the effect of an update statement on the different methods discussed. And as you so properly point out, the proper answer is "it depends".
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes