Before I get into thanking everybody for their comments, last weekend I looked into the performance gains achieved by the "other UNPIVOT" approach because I believe there's no such thing...

I love it when I attract attention from the big boys!

Thanks for the praise :blush: and...

SQLRNNR (7/27/2012)

---

Really unfortunate - I would love to see more from you...

Steven - Glad you found it helpful.

Alas, when I looked at the published article, I found that...

Wow! I would have never imagined that such a simple basic question would generate so much dialogue.

It turns out that I was trying to create a key with 18...

Tom, Bitbucket and Rals - Thanks for dropping by and giving it a shot.

I believe that the limitation on columns participating in an INDEX is the same as for the...

Here's an example using a rCTE:

;WITH MyTable AS (

SELECT TestDate, TestValue

...

Laurie beat me to it. I was going to suggest this:

REPLACE(strcol, '&.', '.')

This will only replace the & if it appears prior to the period.

Gianluca Sartori (7/27/2012)

---

I was offline for a couple of days and I seem to have missed a lot!

Or maybe not. Let's see:

* Celko posting arrogant and upolite replies

* Jeff's splitter...

I say we all take a deep breath and have ¡Mas tequila!

capn.hector (7/26/2012)

---

------Almost pure moden splitter modified slightly to take a NVARCHAR(MAX)

and have a cteTally big enough and eliminate the OR when calculating the start of the string-----

------Aaron version of...

Jeff Moden (7/26/2012)

---

dwain.c (7/26/2012)

---

NEWS FLASH -/-

The SQL-verse was set aflutter today by a purported attempt to debunk the myth perpetrated by Jeff Moden that his DelimitedSplit8K was the fastest 8K...

NEWS FLASH -/-

The SQL-verse was set aflutter today by a purported attempt to debunk the myth perpetrated by Jeff Moden that his DelimitedSplit8K was the fastest 8K SQL-based string splitter...

I am not "he would should not be...

Well :blush:, I meant dog-piling in a professional sort of way of course.