Jeff Moden (6/27/2011)

---

opc.three (6/27/2011)

---

You can use SQLCLR aggregate GROUP_CONCAT to do this (get it here http://groupconcat.codeplex.com):

SELECT jc.OrderNum,

dbo.GROUP_CONCAT(DISTINCT OrdCountry) AS OrdCountries

FROM ...

Jeff Moden (6/27/2011)

---

opc.three (6/27/2011)

---

Please start a new thread 🙂 The OP wanted to know if it was...

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