Professional SQL Server 2005 Programming
Robert Vieira
Wrox/Wiley Pub
For a book that is supposed to be geared to programmers pretty proficient in SQL, it doesn't offer anything new. The examples are very basic and it leaves out some of the new features in 2005, such as Common Table Expressions. This would be better as a beginning SQL programming book.