Glad I could help.

EvilPostIT (3/13/2009)

---

By the looks of things to fix this issue i cannot use the power function as that specifically returns an int value based upon the data type of the...

EvilPostIT (3/13/2009)

---

Yep your right it falls over on the 32nd. Have been working on this since about 5 mins after posting the entire script. Will try and intgrated the new...

Use XmlReader or XmlTextReader to load your XML file into a string, XMLDocument, XMLNode or XMLElement. Then pass it as a parameter value or insert it directly into a...

An even better approach. 🙂

EvilPostIT (3/13/2009)

---

I tried you code but i didnt get the result i expected. Though thanks to the ideas put forward in your script i have managed to get what i...

That's already been explained by the OP as the dreaded...

Hmm, I guess we'll have to disagree on that one, Jeff. 🙂 It still looks to me like the OP was asking why it failed until I added...

This is a curious list of questions. What makes you ask these particular questions?

I don't think that the inserted table columns do not have the Identity property. I would recommend that you check the is_identity property of the sys.columns table instead. ...

Load the XML file into you ADO.net based program and then pass it to SQL as an XML datatype.

GilaMonster (3/12/2009)

---

It's available on...

Steve Jones - Editor (3/12/2009)

---

If you want to run it in SSMS and get the answer, that's up to you. However that kind of defeats the purpose of the questions....

Actually, I think that was the toughest part of this...

If you need to browse for an object or get the objects type, then I would just check the sys.objects table. That's the easiest and most efficient way.