SQL : Simple XQuery Using .Nodes()

DECLARE @xml as XML; 

SELECT @xml = xmlField

From YourTable
Where
XmlId = '855041E’;

SELECT
X.value('OrderId[1]', 'VARCHAR(25)') As [orderid],
X.value('Status[1]', 'VARCHAR(10)') As [status]
FROM @xml.nodes('head/body/response/orders/order') AS T(X);