quote:

---

Originally posted by Peso

You first have to decide what data to insert into the table.
The complete html code, or just the data.

---

E 12°55'05.63"
N 56°04'39.26"

---

quote:

---

Originally posted by Peso

Ok, the table DATA or the table html definition?

---

E 12°55'05.63"
N 56°04'39.26"

---

quote:

---

Originally posted by Peso

DECLARE	@d XML

SET	@d = '
<table>
<tr><TD COLSPAN="4"></TD></tr>
<tr><TD COLSPAN="4"></TD></tr>
<tr align="center"><td rowspan="5">9</td><td><a href="Model-16SH9.html#9">9:25</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#10">10:24</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#11">11:23</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#12">12:22</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#13">13:21</a></td><td> </td><td bgcolor="black"> </td></tr>
</table>
'

SELECT	g.value('@href', 'VARCHAR(MAX)') AS href,
	g.value('.', 'VARCHAR(MAX)') AS a
FROM	@d.nodes('/table/tr/td/a') AS f(g)
WHERE	g.value('.', 'VARCHAR(MAX)') IS NOT NULL

---

E 12°55'05.63"
N 56°04'39.26"

---

quote:

---

Originally posted by Peso

DECLARE	@d XML

SET	@d = '
<table>
<tr><TD COLSPAN="4"></TD></tr>
<tr><TD COLSPAN="4"></TD></tr>
<tr align="center"><td rowspan="5">9</td><td><a href="Model-16SH9.html#9">9:25</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#10">10:24</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#11">11:23</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#12">12:22</a></td><td> </td><td bgcolor="red"> </td></tr>
<tr align="center"><td><a href="Model-16SH9.html#13">13:21</a></td><td> </td><td bgcolor="black"> </td></tr>
</table>
'

SELECT	g.value('@href', 'VARCHAR(MAX)') AS href,
	g.value('.', 'VARCHAR(MAX)') AS a
FROM	@d.nodes('/table/tr/td/a') AS f(g)
WHERE	g.value('.', 'VARCHAR(MAX)') IS NOT NULL

---

E 12°55'05.63"
N 56°04'39.26"

---

quote:

---

Originally posted by revdnrdy

Hello;

I don't recommend storing your table structure inside SQL from a design or performance standpoint. I am curious why someone would do that. If its simply because you are new to html then I would abandon this approach of storing everything on the sql server.

The original poster said he wanted the 'table data' to be stored (not necessarily the structure). Storing the structure is unnecessary and incurs more processing overhead (ie.. parsing). It could also become a maintenance headache.

The better approach would be to code the page structure independent of the data. Then you use a scripting language to retrieve the data from the database and populate your table. A similar approach can be used to update the database from a webpage.

You said you 'didn't know much about html'. I think it is worth the time for you to learn how to get data to and from a webpage from SQL.


r&r

---

quote:

---

Originally posted by mavershang

Thanks for your post.

I have never working with html before. So when I first met this problem, what I thought was to write a perl code, which I am familiar with, to retrieve the data I want and then make a SQL "insert" to create the table in SQL. But obviously that is not so intuitive. So I asked whether there is any other way to import that table.

---