Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ljp099
Yak Posting Veteran
79 Posts |
 Posted - 2007-12-06 : 22:57:46
|
| Im using the Xquery:SELECT @xmlDoc.query('for $item in (/Collection/Content)where $item/Html/root/DocInfo/Webinar = "White Paper"order by $item[1]/Html[1]/root[1]/DocInfo[1]/Title[1] ascendingreturn $item'); I only want to return the TOP 5 nodes (not the entire nodelist). What is the FLOWR expression or simplest way to return the limited nodeset?Thanks |
|
|
|
|
|
Xquery return limited nodeset help