Thanks HTH.
I usually proofread everything before I submit it just to make sure it is
clear, but you go the gist of what I needed.
That helped tremendously it was exactly what I was looking for.
Thanks,
Mike
On Tue, May 20, 2008 at 9:39 AM, Efran Cobisi <[EMAIL PROTECTED]>
wrote:
> Hi Mike,
>
>
Hi Mike,
I am unsure if I understood correctly your requirements (there isn't any
attribute inside your XPath query, isn't it?). However, below you can
find an XPath/SQL query which retrieves both the title and the author
text value for each book element:
SELECT T.C.value('title[1]', 'nvarchar(m
This might be Off Topic but here goes:
I have an XPATH query question regarding element names and how to retrieve
them in SQL Server 2005.
Specifically given this xml document or something similar:
The Way Things Are.
Irene R. Gibson
The Way Things Were.
Kari D. Bednarz
