Topic: SQL Server

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (0470257032) cover image

Beginning T-SQL with Microsoft SQL Server 2005 and 2008

Paul Turley, Dan Wood
ISBN: 978-0-470-25703-6
Paperback
676 pages
December 2008
Other Available Formats: E-book
If you are an instructor, you may request an evaluation copy for this title.
Paperback Version: US $39.99 Add to Cart

About This Title  |  Download Code  |  Errata  |  P2P Forum for This Title
Download TitleSizeDownload
Readme 1.74 KB Click to Download
All Code Downloads for Beginning T-SQL
Chapter 6, Exercise 1 updated on 1/3/2011
23.67 KB Click to Download
Errata: New Code for Chapter 6, Exercise 1
The problem in Chapter 6, Exercise 1 should read:

Write a query to return the average weight of all touring bikes
sold by Adventure Works Cycles that list for more than $2,300.
Use the ProductSubCategory table to determine how you should
filter these products. The correct script would be: -- Exercise 1 Solution ---------------------- -- (Correction from instructions... include touring bikes with
list price over $2,300 rather than $2,500) SELECT AVG(Weight) FROM Production.Product WHERE ProductSubcategoryID = 3 and ListPrice > 2300
23.67 KB Click to Download