Recursive updates in SQL Server (continued...)

I shared with you a few posts, last week, discussing recursive updates in SQL server. We discussed the example of an ecommerce application that needs to display the total count of items under each category. Each category may contain sub-categories and sub-sub-categories etc.

I have made one more post in the same series that uses a recursive CTE to simplify the code I presented in the previous post. http://blog.sqlserver.me/2008/10/sql-server-recursive-update.html