Paul White (5/10/2009)

---

RBarryYoung (5/9/2009)

---

I am talking only about Adam Machanics trick to get around the 8K local context serialization limit for SQL CLR aggregate functions in SQL Server 2005. ...

Paul White (5/10/2009)

---

Barry,

[Brief comments on the first of your two replies]...

It is true that you don't have to convert back from XML if you don't want to, but then it...

What happened today? I had time to work on this today, shame it didn't...

OK, I've looked through it. As I mentioned before, I cannot really test it or try any performance improvements, because I do not have everything that it needs to...

Another problem that I am having is that the latest version of your Proc is making reference to Tables in a Pathfinder database, that you have not given us. ...

PhilM99 (5/7/2009)

---

I'm back. I have gone off and done my homework, hopefully, so let's restart this discussion, and I'll post my code and some test data. I have learned much...

OK, I tried downloading it and then opening it in notepad (in addition to my usual of opening it in another Firefox tab). Both of these came out fine...

It formatted fine for me?

Florian Reischl (5/9/2009)

---

Hi Barry

That have been also my first...

Paul White (5/9/2009)

---

Once one has added TYPE and .value(/.[1], 'varchar(x)') the plan has gained an XML Reader, two UDX operations, a stream aggregate, and two loop joins - just to...

Paul White (5/9/2009)

---

RBarryYoung (5/9/2009)

---

Actually, as far as I can tell, the FOR XML PATH('') trick in fact uses this (or a very similar) method internally and consequently it scales the...

Paul White (5/9/2009)

---

I know. It seems to be the same most everywhere. Kinda depressing!

RBarryYoung (5/9/2009)

---

In such circumstances I usually ask the decision...

Paul White (5/9/2009)

---

A StringBuilder. A CLR aggregate based on a StringBuilder.

Such as implementation gets plugged directly into the plan...

Florian Reischl (5/9/2009)

---

Nope. The customer!

Sure, the tester also found this "feature" (as first) but the TPM thought there is no time to fix it for the first version and the...

Yes. You will need to use recursive CTE's (Common Table Expressions).