hello

the following code worked BUT how do I join this to another table (select xs_id from new_table)

WITH XMLNAMESPACES (DEFAULT 'urn:vim25')

,BASE_DATA AS

(

SELECT

...

hello

thank you for your time ,no luck.

how do I get data without declare stmt as i cannot declare 1000 rows or more and xml data type but return...

Hi

thank you again but this is not xml datatype its ntext data type

CREATE TABLE [dbo].[SYSTEM_ID_INFO](

[ID] [int] NOT NULL,

[SYSTEM_ID] [ntext] NULL)

I apologize for not being clear

I have to pull this data from table with 1000 rows like this

Wondering , where in the query I plug in the actual column names...

thank you.is this how I replace my column names?when I do I get the following errors

SELECT

sys_id('(HostSystemIdentificationInfo/identifierValue/text())[3]','varchar(50)')

,sys_id('(HostSystemIdentificationInfo/identifierValue/text())[4]','varchar(50)')

FROM host_sys);

sys_id is not a recognized built-in...

hello

Thank you for your response and have following questions

1.can we split the data into two columns and your query returns all in one

2.based on your reply how do I write...