Yep. Dead and buried under a pile of pork chop bones 😉

Hey,

Have you considered the possible benefits of having a go at these (presumably homework) questions?

Sure posting on here and kicking back may seem cool, but how...

Hey Dean,

Could post a brief snippet or two to illustrate the similarities and differences between the queries please?

There are a number of options here, but most depend on how similar...

ROFL! :w00t:

Any budgetary constraints Jeff?

If I win the lotto this weekend, I know which one I would buy.

(NZ) $17,500 is...

UMG Developer (5/12/2009)

---

I may have to see if I can get them to let me try the CLR splitter out on the dev server, but I think they will be...

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

[font="Courier...

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.

Paul

Zarking fardwarks Jeff! :w00t:

How many points for: http://www.youtube.com/watch?v=AM_fpspCq2c

Duplicate post :blush:

I believe he is referring to the (...FOR XML PATH('')).value('./[1]')...

All T-SQL UDFs under all circumstances...

Jeff Moden (5/12/2009)

---

Paul White (5/12/2009)

---

Oh...

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

T-SQL UDFs always generate a serial plan.

(CLR UDFs don't - unless defined with a MAX...