SQL Server 2005 Bible
Paul Nielsen
Wiley
This book is well written, easy to follow and easy to apply the code as presented.  I would give it a "5" if it had the code samples for creating SQL for a report that includes multiple fields and a subtotal by grouping and a grand total for the report.  While there is some information in this book, it does not assist well in solving this particular problem.

Overall, worth the money for a reference if you are a SQL Developer, DBA, BSA, or an instructor or trainer.