You're welcome 🙂

They missed the boat.

Like I said, not arguing anything you said. Compliance was not the issue at hand in my scenario.

Nadrek (6/27/2011)

---

opc.three (6/27/2011)

---

Elliott Whitlow (6/27/2011)

---

Agreed. It was not specifically for the benefit OP, but for me 😀 I would not implement the component as an Enterprise solution unless it could...

Seriously, WTF is that? 😛

If you're using the # prefix SQL Server will ignore it and use tempdb anyway. This:

CREATE TABLE AdventureWorks.dbo.#tbl (a INT);

Results in a table being created in tempdb and this warning...

The function ufnGetContactInformation in this Books Online article is a mTVF...

I don't know of antyhing in native T-SQL that can do what you're asking. SQLCLR could provide the illusion of native T-SQL, or you could shell out to a cmd...

Barret-330682 (6/27/2011)

---

What should the proper syntax be to pull the data back where value2 is yo5?

SELECT AdditionalData.value('

declare namespace C="test";

(/C:DocumentElement/C:AdditionalData/C:Value2)[1]', 'VARCHAR(12)') AS answer

from table

I am trying to pull data from an...

Boooo 🙂 Poor design. Please save yourself the trouble and do not do this work in a trigger. Save your "work to do" request to a table and have another...

You're welcome 🙂

PS You did a nice job posting the problem and expected results in your initial post, but I would not have posted a solution had you not provided...

No, not in your scenario.

Do you mind posting some sample DDL and DML so we can build tables on our side, as well as the query(ies) you have tried so far?

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

You're on the right track, you need to find the right balance between your max memory setting and MemToLeave.

You could look at using SQLCLR to call out to the service, but that would open a whole can of worms regarding security.

Why can't the service retrieve the XML from...