Hi

I know a fair bit about SQL, but i have always avoided learning T-SQL and
how to create Reporting Services reports.  Now that SQL Reporting Services
is fast becoming the "must have reporting tool",  i would like to learn
etc..

Does anyone recommend any Transcat SQL books to help me create tables, join,
compare etc....  and SQL 2005 Reporting services book to create rich looking
reports please?

I am keen to learn the above to gain the MCTS credition
http://www.microsoft.com/learning/mcp/mcts/sql/

Regards

For T-SQL I would go with this book in my opinion it's  the best out
there
The Guru's Guide to Transact-SQL by Ken Henderson
http://www.amazon.com/exec/obidos/tg/detail/-/0201615762/ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books

For reporting services take a look at the following 2 books
Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson
http://www.amazon.com/exec/obidos/ASIN/0072262397/sql08-20/102-5735017-0910517?%5Fencoding=UTF8&camp=1789&link%5Fcode=xm2

or

Professional SQL Server 2005 Reporting Services by Paul Turley, Todd
Bryant, James Counihan, George McKee, Dave DuVarney
http://www.amazon.com/exec/obidos/ASIN/0764584979/sql08-20/102-5735017-0910517?%5Fencoding=UTF8&camp=1789&link%5Fcode=xm2

Have fun

http://sqlservercode.blogspot.com/

SQL 2000 on W2k fragmentation
Performance: Primary Key = int/nvarchar/guid/...
Stop & Start SQL Server for using scm
Trusted Connection failing
How do I get my local data in the database on the Internet?
Memory allocation in MS-SQL 2000 instances
Windows says SQL is installed, but it's not!
Why do Ado.net don't use execution plan that Query Analyzer
Switching off logging on varbinary column
Multiple jobs on one schedule