There are several books authored by Itzik Ben-Gan that are exceptionally good:

SQL Server 2008 T-SQL Fundamentals

Inside SQL Server 2008 T-SQL Querying

One of his SQL Server 2012 books is available now:

SQL Server 2012 High-Performance T-SQL using window functions

Editor: Removed link