Errata

Initial printing

Page	Location	Correction
65	Paragraph before final Input block, words: with the letter J or the letter M	Should be: with the letter E or the letter J
72	Third bullet, words: The state stored	Should be: The country stored
76	TIP, 5th line, words: SELECT TRIM(‘ ABC ‘)	Should be: SELECT LTRIM(RTRIM(‘ ABC ‘))
83	Table 10.3, weekday, text in parentheses	Should be: (DateName() and DatePart() only)
84	Second INPUT block, second line of code	Should be: DateName(weekday, order_date) AS weekday
85	Analysis block, second line, both code examples	Second parameter to DateName() should be an actual date
85	Line before bulleted list: of dates	Should be: of dates, including
104	Line after TIP box: So how do you filter rows?	Should be: So how do you filter groups?
131	Final INPUT block contains the wrong SQL statement	Should be: SELECT customers.cust_id, customers.cust_name FROM customers INNER JOIN orders ON customers.cust_id = orders.cust_id WHERE DateDiff(month, order_date, ‘2005-09-01’) = 0
230	Second INPUT block	Should be: SELECT @cheap AS Cheap, @expensive AS Expensive, @average AS Average
230	First INPUT block	Should be: SELECT @cheap AS Cheap
242	Analysis block, line beginning “grant total”: grant	Should be: grand
242	Final line of INPUT block: GrantTotal	Should be: GrandTotal
312	Table D2, description for BIGINT	Second number should not have – in front of it