Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

The reviewers before me elaborated enough about this amazing book, so I don't have much to add. This book deserves nothing but 5 stars and I don't understand reviewers giving it less than 5... If one codes in SQL (level is not relevant) he must have this book right next to him all the time (forgive my sexism). Some solutions in this book (like aggregations using XPATH) are screamingly elegant and effective. I very much admire the organization of the book: from problem definition to solution, in easy to follow format. This book totally turns you away from google's search bar and makes you praise every penny you spent on it. Great job, Itzik!