Tuesday, 17 February 2015

How to extract specific string part from the SQL String variable



I have an Sql Variable which contains a string value and want to extract specific part from that string value,



Declare @val as nvarchar(1000),
       @outval as nvarchar(1000)

     set @val='<Message>
  <Header>
  <MessageID>000000015</MessageID>
  <MessageType>QualityData</MessageType>
   <Sender>Data</Sender>
  <Recipient>Data1</Recipient>
  <PublishedDate>2013-12-22T13:15:23</PublishedDate>
 </Header>
<Body>
 <ID>150105</ID>
 <Data>
   <Count>5</Count>
   <Brix>110</Brix>
   <CO2>110</CO2>
  </QualityData>
</Body>
</Message>'


Now i need to extract string from to using sql query. Output should be like as below.



      <Body>
<ID>150105</ID>
<Data>
  <Count>5</Count>
  <Brix>110</Brix>
  <CO2>110</CO2>
</QualityData>


any suggestion to get this format using SQL Server.


No comments:

Post a Comment