Would you mind elaborate the business case?

Especially the part

Why do you compare the median...

What exactly are you trying to do here?

Your "CASE WHEN '2006'..." (and all other similar case statements) don't really make sense. What variable/column is supposed to have a value of...

RBarryYoung (3/2/2010)

---

...

First, I am convinced that this is just too big to fit into a Forum post. Secondly, I realize that we have sort of hijacked the OPs thread...

david.pelizzari (3/2/2010)

---

lmu92 (3/2/2010)

---

You should look for split string functions on this site.

There are numerous solutions available.

One pretty fast solution is described at the end of the Tally Table article referenced...

To me it looks more likt...

Hunterwood (3/2/2010)

---

Here is one way to solve the problem:

declare @str varchar(200)

set @str = 'Apple, Banana,Orange, Pinapple, Lemon'

declare @result table (string varchar(100))

declare @start int

declare @end int

set @start = 1

set @end =...

You should look for split string functions on this site.

There are numerous solutions available.

One pretty fast solution is described at the end of the Tally Table article referenced in my...

Yatish,

is there any specific reason for reposting the same question that can be found here ??

Not only that you split answers across multiple threads, you'll also have several people...

The two query plans are not identical.

The slow plan is actually processing 2.509.700.160 (2 and a half billion!) rows from tempdb.dbo.#revdates (estimated: 454080). See the thick arrow on the left...

Jeff Moden (3/1/2010)

---

...

I know you know this, Lutz... just saying this in case anyone thinks otherwise....

Don't rely on the execution plan for differenences in performance either. Sure, it...

Actual (not estimated) execution plan. saved as .sqlplan and attached to your post would help a lot.

I hope they'll set up those great public viewing areas again like they did in 2006 over here in Germany....

I just stumbled across that Simple Talk article .

I found it very interesting and descriptive. To me the most important message is to not only rely on the results...

Well, you could setup each step of your proc...

Paul White (3/1/2010)

---

I was labouring under a misapprehension as far as the Olympics were concerned: I had always thought that the country with the highest number of Gold Medals came...