I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months back about me book list for SQL Server 2012. You can find that post here. In terms of T-SQL I have a couple of books that I Like

1. Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer)

2. Inside Microsoft SQL Server 2008: T-SQL Querying

3. Inside Microsoft SQL Server 2008: T-SQL Programming (Pro-Developer)

If you have any book recommendations for learning TSQL that are not listed here please leave a comment and let me know