How to remove the table tr td in sql server

Question

  i have one table in that table i have one column in that record as follows

 

         SummaryList  record as follows

 

<table WIDTH="100%"CELLPADDING="1"CELLSPACING="1">

 

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">

   <td><b>Report Date : </b>2016-11-21 </td>

  <td><b>Optometrist : </b> </td>

  <td><b>Start Time : </b> </td>

</tr>

 

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">

        <td><b>Consultant : </b>Dr.Suresh </td>

</tr>

 

</table>

 i want to remove table tr  td and i want only content as follows

 

 

  from the above i want output as follows

 

 Report Date: 2016-11-21 Optometrist: start Time: Consultant: Dr.suresh

 

for that how to do using sql server 

Answer 1

<b> Report Date:&nbsp;&nbsp; 2016-11-21 &nbsp;&nbsp;Optometrist: &nbsp;&nbsp;start &nbsp;&nbsp;Time:&nbsp;&nbsp; Consultant: &nbsp;&nbsp;Dr.suresh</b>

Answer 2

Hi,

 

Please try below query - 

DECLARE @x XML = '<table WIDTH="100%" CELLPADDING="1" CELLSPACING="1">

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
   <td><b>Report Date : </b>2016-11-21 </td>
  <td><b>Optometrist : </b> </td>
  <td><b>Start Time : </b> </td>
</tr>

<tr style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt;BACKGROUND-COLOR: #f2f2f2;">
        <td><b>Consultant : </b>Dr.Suresh </td>
</tr>

</table>'

SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)

 

Reference :

https://stackoverflow.com/questions/38868364/sql-remove-all-html-tags-in-a-string