Given the following syntax in SQL Server 2005:

Maybe this?

select Data.Student.value('@id', 'varchar(6)') as id,
Data.Student.value('(Name)[1]', 'varchar(30)') as [name],
Data.Student.value('(Class)[1]', 'varchar(50)') as class ,
Data.Student.value('for $a in . return count($a/../*[. << $a]) +
1','int') as ndx
from @xmlvar.nodes('/Data/Student') Data(Student)

Mark,

Thanks that definitly gets me going in the right direction. Can you explain
the statement count($a/../*[. << $a]) , other than count() I get lost after
the "[".

Thanks,

Matt

hotmail.com> wrote in message
news:1169684064.504759.156860@q2g2000cwa.googlegroups.com...

Mark,

Thanks for the explanation but I am confused by something I am getting with
one of my queries. Using your recommended method works great on one part of
the XML I am working with but in another area the number starts at 7. If I
run different things I get different values. Any ideas? I can't post the
actual XML I am working with but I can send it to you if you would like to
see my issue with my query.

Thanks,

Matt