Beginning Transact-SQL with SQL Server 2000 and 2005

ISBN: 978-0-7645-7955-4

Paperback

600 pages

October 2005

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

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.

Page	Details	Date
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