I just published a new article on SearchSQLServer.com called Processing XML files with SQL Server functions.
In this article I talk about how to get data from XML files on disk into the SQL Server, and then provide examples on how to use OPENXML to turn the XML data into tabular data so that you can use it within SQL Server.
Denny