Change your function's variable declaration to use NVARCHAR, and not Varchar.

Lutz just brought up a good point: if this is your presentation format, do NOT convert it back to the XML data type (it will strip out the XML...

lsurapaneni (12/22/2010)

---

Thank you so much Wayne.

I tried your solution, but I am not getting the below 3 lines of code in my output:

<?xml version = "1.0" encoding="UTF-8" ?>

<!DOCTYPE empload...

SQLkiwi (12/20/2010)

---

Precisely. It's just an oversight in the parser:

--...

Wildcat (12/20/2010)

---

That is for DELETE or UPDATE statement, not for the SELECT.

BTW, how could a NOLOCK hint to the target table on the DELETE or UPDATE statement? Make no sense...

The "hints" he is referring to would be the (nolock) query hints throughout...

Jeff Moden (12/14/2010)

---

I'll take both, please. You've got to know your stuff and be able to work with people to get the job done. Well... unless you're flippin' your...

Malcolm's reference to a man in the middle attack is a huge security issue. Not being able to control or block alternate protocols...

Malcolm Daughtree (12/14/2010)

---

Been doin'...

Lowell (12/11/2010)

---

Malcolm Daughtree (12/10/2010)

---

Uhhh. Because it's a SQL server NOT a firewall. What Idiot would expose a SQL server to the wilds of the internet for it to...

Steve Jones - SSC Editor (12/8/2010)

---

Well I still wish I was Ben Kenobi. The...

yep!

Nothing like going to the beach the following year and asking my parents:

"Is that the same ocean where the shark is...

Richard.Westhaver (12/6/2010)

---

Sorry, have to add my 2 cents in on this. I'm dating myself when i say this, I was about 7 when we went to the...

Stefan Krzywicki (12/6/2010)

---

Kit G (12/6/2010)

---

Ah ha! I knew it! Google is run by...

Jason Marshall (12/3/2010)

---

Recently a new group moved across the aisle from us, and they're on calls all day (one with an unbelievably annoying voice), so I started bringing my MP3...