Database

Select
	Convert(xml, '<?xml version="1.0" encoding="utf-8" ?>
<Employees>
	#foreach emp in emp begin#
	<Employee id="emp.EmployeeID#">
		<Manager id="#emp.BossID#">#emp.BossName#</Manager>
		<Addresses>
		#foreach addr in emp.Address1 begin#
			<Address id="#addr.AddressID#">#addr.Address1 + " " + addr.City + ", " + addr.State + " " addr.ZipCode#</Address>
		#end#
		</Addresses>
	</Employee>
	#end#
</Employees>
	') As EmployeeDoc
From
(
	Select
		emp.ID			As EmployeeID
		,emp.Name		As EmployeeName
		,boss.ID		As BossID
		,boss.Name		As BossName
		,addr.ID		As AddressID
		,addr.Address1
		,addr.City
		,addr.State
		,addr.ZipCode
	From
		Employees emp
		Left Join Employees boss
			On emp.ManagerID = emp.ID
		Inner Join EmployeeAddresses empaddr
			On emp.ID = empaddr.EmployeeID
		Inner Join Addresses addr
			On empaddr.AddressID = addr.ID
	Where
		emp.TerminationDate Is Null
) tbl;