Executing XPath Queries Using Templates
The <sql:xpath-query> tag is used to specify the XPath query in the template. The XPath query is executed against the annotated XML-Data Reduced (XDR) mapping schema specified using he mapping-schema attribute of the <xpath-query> element. For more information about XDR schemas, see Creating XML Views Using Annotated XDR Schemas. For more information about XPath queries, see Using XPath Queries.
The mapping XDR schema specified in the template must be stored in the directory associated with the template virtual name (created using IIS Virtual Directory Management for SQL Server utility) or one of its subdirectories, in which case you must specify the relative path in the mapping-schema attribute.