/* 1. From the HumanResources.Employee table write a query in SQL to retrieve all rows and columns from the employee table in the Adventureworks database. Sort the result set in ascending order on ...

AdventureWorks Corporation's retail analytics platform needs a reusable programmability layer — stored procedures, scalar functions, table-valued functions, and table-valued parameters — to ...

Books Online does have an example, but lo and behold it runs against the 2005 version of AdventureWorks. Since I was using SQL Server 2008, I had loaded AdventureWorks2008 which includes significant ...