XQuery syntax to account for schema definition

[bestweb]

Environment: SQL Server 2012.Say I have a table Message with xml column WordIndex. I also have a table Word which has WordId and WordText. Xml for Message.WordIndex has the following schema:\[code\]<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://www.example.com"> <xs:element name="wi"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="w"> <xs:complexType> <xs:sequence> <xs:element maxOccurs="unbounded" name="p" type="xs:unsignedByte" /> </xs:sequence> <xs:attribute name="wid" type="xs:unsignedByte" use="required" /> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element></xs:schema>\[/code\]and some data to go with it:\[code\]<wi xmlns="http://www.example.com"> <w wid="1"> <p>28</p> <p>72</p> <p>125</p> </w> <w wid="4"> <p>89</p> </w> <w wid="5"> <p>11</p> </w></wi>\[/code\]I also have SQL queries with XQuery code like this:\[code\]with WordIds as( select distinct t.c.value('@wid', 'int') as XmlWordId from Message as m cross apply m.WordIndex.nodes('/wi/w') as t(c) inner join Word as w on w.WordId = t.c.value('@wid', 'int')-- some more joins go here ...)select count(*)from WordIds\[/code\]and this (this one doesn't work, since I started to introduce schema into it):\[code\]with xmlnamespaces('http://www.example.com' as ns)select wi.Position, w.WordId, w.WordTextfrom( select t.c.value('.', 'int') as Position, t.c.value('../@wid', 'int') as WordId from Message as m cross apply m.WordIndex.nodes('//p') as t(c) where m.MessageId = @MessageId) as wiinner join Word as w on w.WordId = wi.WordIdorder by wi.Position\[/code\]Question:What is the proper syntax to qualify arguments to calls to .value() and .nodes()?I get errors that I don't fully understand:\[code\]XQuery [Message.WordIndex.value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:anyAtomicType *'\[/code\]