1. XML Workshop I - Generating XML with FOR XML
2. XML Workshop II - Reading values from XML variables
3. XML Workshop III - FOR XML PATH
4. XML Workshop IV - FOR XML EXPLICIT
5. XML Workshop V - Reading Values from XML Columns
6. XML Workshop VI - Typed XML and SCHEMA Collection
7. XML Workshop VII - Validating values with SCHEMA
8. XML Workshop VIII - Custom Types and Inheritance
9. XML Workshop IX - Mixed Types
10. XML Workshop X - Working with namespaces
11. XML Workshop XI - Default Namespaces
12. XML Workshop XII - Parsing a delimited string
13. XML Workshop XIII - XSD And Variable Content Containers
14. XML Workshop XIV - Generating an XML Tree
15. XML Workshop XV - Accessing FOR XML results with ADO.NET
16. XML Workshop XVI - Shaping the XML results
17. XML Workshop XVII - Writing a LOOP to process all XML nodes
18. XML Workshop XVIII - Generating an RSS 2.0 Feed with TSQL

and also  XML Import Solution