SELECT only first element using XQuery

Below is the example of how to select only first element from whole bunch of XML in sql server.

declare @x xml;

SET @x=’<Statuses>

<Status DateAndTime=”">

<one State=”" Desc=”" />

<two State=”" Desc=”" />

<three State=”" Desc=”" />

</Status>

<Status DateAndTime=”">

<four State=”" Desc=”" />

<five State=”" Desc=”" />

<six State=”" Desc=”" />

</Status>

</Statuses>’

SELECT @x.query(‘(Statuses/Status)[1]‘)

declare @x xml;SET @x=’<Statuses>        <Status DateAndTime=”">                 <one State=”" Desc=”" />                 <two State=”" Desc=”" />                 <three State=”" Desc=”" />        </Status>        <Status DateAndTime=”">                 <four State=”" Desc=”" />                 <five State=”" Desc=”" />                 <six State=”" Desc=”" />        </Status></Statuses>’
SELECT @x.query(‘(Statuses/Status)[1]‘)

Advertisement