narasiman rao

narasiman rao

  • NA
  • 519
  • 768.3k

How to remove the table tr td in sql server

Dec 11 2017 3:20 AM
  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 

Answers (2)