mjohnson-909671 (1/6/2010)
The temporary table does not contain a column "CategoryName". It attempts to update a column that does not exist. It would throw an error, not return rows.
Take a closer look at the code. CategoryName is being updated in the Categories table. The OUTPUT clause is inserting the Old and New Category names into a temporary table as an audit of changes.