How we can read all OrderId. I am using the following code to read but it is reading only first orderId
Sample Code
DECLARE @InputXMLHandle int Declare @RequestXml xml = ' <Request> <OrderStatus> <OrderId>RSIN10095</OrderId> <OrderId>RSIN10096</OrderId> </OrderStatus> </Request> ' EXEC sp_xml_preparedocument @InputXMLHandle OUTPUT, @RequestXml Select * From OPENXML(@InputXMLHandle,'/Request/OrderStatus') WITH ( OrderId varchar(50) 'OrderId' )