Hi Gary,

The Advance Transact-SQL for SQL Server 2000 is from Apress at apress.com and the The Guru's Guide to Transact-SQl is from Addison Wesley at www2.awl.com. I had Barnes and Noble order the books and when they came in I looked through them and found they used different approaches and perspectives to solve the same syntax problem (which I think is great). These two books along with inside SQL server 2000 help me solve most problem I have run into so far.

I hope this helps

Andy