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 = '
RSIN10095
RSIN10096
'
EXEC sp_xml_preparedocument @InputXMLHandle OUTPUT, @RequestXml
Select *
From OPENXML(@InputXMLHandle,'/Request/OrderStatus')
WITH
(
OrderId varchar(50) 'OrderId'
)

Praveen KumarPosted Jun 18, 2021, 9:33 AM