----------------------------  select * from devicepool,device,DeviceNumplanMap,NumPlan where device.fkdevicepool=devicepool.pkid 
and  Device.pkid=DeviceNumplanMap.fkDevice ----------------------------
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><SOAP-ENV:Header/><SOAP-ENV:Body><axl:executeSQLQueryResponse xmlns:axl="http://www.cisco.com/AXL/API/1.0" xmlns:xsi="http://www.cisco.com/AXL/API/1.0" sequence="1268323502180"><return><row><devicepool>IDDQQ</devicepool><devicename>XXX001XXX954XXX</devicename><description>FF:IDDQQ</description><display>FF:APWO</display><label>9417041</label><intnumber>12105</intnumber><extnumber>412422110</extnumber></row><row><devicepool>FF</devicepool><devicename>XXX001XXX954XXX</devicename><description>FF:</description><display>FF:</display><label>17041</label><intnumber>17041</intnumber><extnumber>412422110</extnumber></row></return></axl:executeSQLQueryResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

--объявляем переменные
declare @idoc int
declare @xml varchar(8000)

--испортим данные XML
drop table #t
create table #t(xml varchar(8000))
bulk insert #t from '\\vlasov\svalka\test.xml' with(ROWTERMINATOR = '')
	
--парсим документ
set @xml = (select substring(xml, charindex('<?xml', xml), 8000) from #t)
exec sp_xml_preparedocument @idoc OUTPUT, @xml

--получаем результат
select
*
from
--	openxml(@idoc, '/SOAP-ENV:Envelope/SOAP-ENV:Body/axl:executeSQLQueryResponse/return', 8)
	openxml(@idoc, '//return/row', 2)
	with (
		devicepool varchar(20) 'devicepool', 
		devicename varchar(20) 'devicename',
		description varchar(20) 'description',
		display varchar(20) 'display',
		label varchar(20) 'label',
		intnumber varchar(20) 'intnumber',
		extnumber varchar(20) 'extnumber'
	)
exec sp_xml_removedocument @idoc