An updated version of SQL Server 2005 Books Online is available from the
download center
(http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx).

Please see the topic "New and Updated Books Online Topics (17 July 2006) "
for links to the new and updated topics in this release.
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlwhtn9/html/be97726e-e501-4b4a-b40d-86682bb7a73b.htm).

The Books Online topics available via MSDN
(http://msdn2.microsoft.com/en-us/library/ms130214.aspx) will be updated
this weekend.

Combining 2 select statements
column dataType
Applying a function to a subquery
Query from a dynamic table
Case statement question