Much the same as the others who have posted.

There is no shortage of information or material overload in SQL, databases or even Oracle.

If you have the desire to learn and...

Yes recursive CTEs can be slow - you need to be sure you have defined your recursion well enough.

I have seen them perform marvelously as well. For instance we...

For a very similar requirement we backed up and restored databases from one server to another on a nightly basis. It was much faster (due to size) to backup...

That's what conference calls are for:-D:-D

It sounds like the metadata just needed updated. By chance were the two columns similar in name? Or did you remove one, then add it back and then...

Yes you can.

You would create a data connection to the database inside your script and then insert those records into the table.

Here is an article on creating such a connection.

http://msdn.microsoft.com/en-us/library/ms135939.aspx

Congrats - that is good.

Can you run the query and retrieve the XML - then try clicking the xml link and see if it behaves differently?

Boardwalk

Evil Kraig F (11/3/2011)

---

Anyone else been having serious problems with posting today? Edits, quotes, even just add reply is being feisty. Won't seem to trigger the post creation...

Evil Kraig F (11/3/2011)

---

SQLRNNR (11/3/2011)

---

GSquared (11/3/2011)

---

I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant...

GSquared (11/3/2011)

---

I just found a stored procedure from my predecessor at my current job, and it just kind of made my jaw drop in the elegant simplicity of it's complete...

GilaMonster (11/3/2011)

---

Brandie Tarvin (11/3/2011)

---

And why...

Buffet

underactive