The query below shows how to create an XML document using FOR XML from a table (based on Sql Server 2000). To start with, run the sql script further below to create the sample table, and populate it with some data. Once the select script is run, data will be returned in the form: <Employees> <Employee> <field1></field1> ... </Employee> </Employees> Query select 1 as Tag, NULL as Parent, NULL as [Employees!1!Employee!xml], NULL as [Employee!2!OfficerId!xml], NULL...