Jeff Moden (5/10/2009)

---

I'm confused... why would you put over 4 million comments together only to break them apart again?

Paul White (5/12/2009)

---

Try embedding CHAR(11) or CHAR(27).... 😛

Paul White (5/12/2009)

---

UMG,

So is the parallel tally fast enough for you? Seems fairly reasonable to me.

Try: exec sp_configure 'clr_enabled', 1; reconfigure;

...some day 🙂

It's that hard.

Jeff Moden (5/12/2009)

---

If anyone knows what the ".VALUE trick" that UMG was talking about is, I'm all ears, thank you. :w00t:

Florian Reischl (5/12/2009)

---

Here is the cursor I actually used in my tests. I compared it with all others but it seems to be the fastest.

Paul White (5/12/2009)

---

Do you get parallelism with Jeff's solution? I would think that would help a lot.

T-SQL UDFs always generate a serial plan.

Florian Reischl (5/12/2009)

---

Well, errmm... You need bigger hardware! 😀

Seems to depend on the count of rows. I will inspect later today. Do you know how long the previous steps took?

Florian Reischl (5/11/2009)

---

Well, this brings up some more "fun"!

I did some changes in my previous version. Give it a try:

UMG Developer (5/11/2009)

---

1 Line1|Line2|Line3