Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijayakumar_svk
Yak Posting Veteran
50 Posts |
 Posted - 2006-02-11 : 19:15:20
|
| Hi,I have a Html string stored in a column. Each column in the html table cell is corresponding to one column in sql server table.First row in the html is the column headings and the remaining rows are data for those columns. Is it possible to get the columns from that html string using query?Eg Data: <table> <tr> <td id='0.0'><![CDATA[ID]]></td> <td id='0.1'><![CDATA[Name]]></td> <td id='0.2'><![CDATA[Age]]></td> </tr> <tr> <td id='1.0'><![CDATA[1]]></td> <td id='1.1'><![CDATA[ABC]]></td> <td id='1.2'><![CDATA[20]]></td> </tr> <tr> <td id='1.0'><![CDATA[2]]></td> <td id='1.1'><![CDATA[XYZ]]></td> <td id='1.2'><![CDATA[23]]></td> </tr> <tr> <td id='1.0'><![CDATA[3]]></td> <td id='1.1'><![CDATA[PQR]]></td> <td id='1.2'><![CDATA[45]]></td> </tr> </table>Expected Result: ID Name Age 1 ABC 20 2 XYZ 23 3 PQR 45I tried with OPENXML. But we need to store the values as attribute of a node not an element to get the result from OPENXML. I am not having a option to change the format of the storage. So I am looking for a solution to get the values from the given format of string.If anyone have any idea on how we can approach this problem please let me know.Thank you in advanceVJYou can mail me also : vijayakumar_svk@hotmail.comWork smarter not harder take control of your life be a super achiever |
|
|
vijayakumar_svk
Yak Posting Veteran
50 Posts |
Posted - 2006-02-27 : 17:20:05
|
| Any help for the question?Work smarter not harder take control of your life be a super achiever |
 |
|
|
vijayakumar_svk
Yak Posting Veteran
50 Posts |
Posted - 2006-03-15 : 12:58:08
|
| Hey!! No one is intereseted on this?Work smarter not harder take control of your life be a super achiever |
|
|
|
|
|
|
Html Content To SQl Table