stoyan
asked on
strange result
i have this query in sql2000:
declare @XML nvarchar(1024),
@idoc int
set @XML = '<App>
<Nam>AAAA</Nam>
<Nam>BBBB</Nam>
</App>'
exec sp_xml_preparedocument @idoc output, @XML
select *
from openxml(@idoc, '/App', 2)
with
(Nam nvarchar(128) '../App/Nam')
My question is: why would it return 1 row when it should return two result rows ??
could anyone help ???
declare @XML nvarchar(1024),
@idoc int
set @XML = '<App>
<Nam>AAAA</Nam>
<Nam>BBBB</Nam>
</App>'
exec sp_xml_preparedocument @idoc output, @XML
select *
from openxml(@idoc, '/App', 2)
with
(Nam nvarchar(128) '../App/Nam')
My question is: why would it return 1 row when it should return two result rows ??
could anyone help ???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this works fine