Wrox Home  
Search

Topic: SQL Server

Beginning Transact-SQL with SQL Server 2000 and 2005 (076457955X) cover image

Beginning Transact-SQL with SQL Server 2000 and 2005

Paul Turley with Dan Wood
ISBN: 978-0-7645-7955-4
Paperback
600 pages
October 2005
This title is out-of-print and not currently available for purchase from this site.


Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
45 AdventureWorks2000 link
The link in the book is wrong. I could not locate AdventureWorks2000 sample database for download.

http://www.wrox.com/go/begintransact-SQL

The above link does not work....
It should be the following:

http://www.wrox.com/WileyCDA/WroxTitle/productCd-076457955X,descCd-download_code.html
1/13/06
99-100 Error in Figure Position
Figure 3-56 was placed on the wrong page, after the next section heading. The figure numbers are correct but the placement of this figure is incorrect.
11/14/05
114 Error in Code
in last line of code:
Customer.CustomerIDCustomer

Should be:
Customer.CustomerID
7/24/06
177 Error in Code
Code reads:

SELECT DATEADD( mi, -9000000, '4-29-1988 10:30 AM')

Should read:

SELECT DATEADD( ms, -9000000, '4-29-1988 10:30 AM')
04/06/2006
390 Error in Function
Top of the page:
calling function dbo.fnFirstName

Should be:
calling function fnGetName
(as created in previous example)
04/09/07
529 Error in Solution
The solution script printed at the bottom of page 529 is not relevant to the exercise. The correct solution should read as follows:

SELECT * FROM
(SELECT TOP 10 FirstName + ' ' + LastName AS Name, BaseRate
FROM Employee ORDER BY BaseRate DESC) AS E1
UNION ALL
SELECT * FROM
(SELECT '(Other)' AS Name, AVG(Employee.BaseRate) AS BaseRate
FROM Employee
LEFT OUTER JOIN
(SELECT TOP 10 EmployeeID, BaseRate FROM Employee ORDER BY BaseRate DESC) AS E2
ON Employee.EmployeeID = E2.EmployeeID
WHERE E2.EmployeeID IS NULL) AS E3
10/08/08
Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free