On page 503, at the bottom of the page, after keyword UNION the keyword SELECT is missing. The code should read:

SELECT -1 AS ProductCategoryID, '(All Categories)' AS Name
UNION
SELECT ProductCategoryID, NAME
FROM Production.ProductCategory
ORDER BY Name

Thank you. This issue had been reported several months ago and should have been entered into the book errata log. I've followed up with the forum administrator to make sure it gets logged and will be available to readers.

__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access