Here's a list of some books I am recommending.
SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach (A Problem – Solution Approach) by Joseph Sack
Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) by Itzik Ben-Gan
Inside Microsoft SQL Server 2000 by Kalen Delaney