strange result

[esdee]

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 ???

 

[esdee]

i got an answer
thanx anyway

 

[OLAPer]

stoyanbd

It would be useful if you would share your answer with the rest of us......

It is important to use these types of groups for both asking questions, but also providing help and assistance, so that if someone else has a similar question they don't have to start a new posting !!!!

Thanks v. much


OLAPer