"The end of the world is Nige". Don't you watch monochrome movies, Lowell?

Nige.

Satnam Singh (6/28/2012)

---

Friends,

I am having a serious performance problem with the below query:

SELECT DATEADD(mi, (SELECT BiasInMinutes FROM A WHERE ...

SELECT whatever

FROM table

WHERE [field]=@var

UNION ALL

SELECT whatever

FROM table

WHERE @var = 'A' and field = 'B'

dwain.c (6/22/2012)

---

To answer my own question:

CPU...

There's a simple solution for this. Anyone remember the challenge of obtaining every possible combination of the letters of the alphabet, starting A, AB, AC.....BC, BD, BE......ABCDEFGHIJKLMNOPQRSTUVWXYZ....ZY, ZZ?

Generate instead a...

Hi Les

Good challenge, top work. One question: sooner or later someone will post a solution and you will have to test it. Will you use your sample data set or...

Have you tried a VALUES list? With CROSS APPLY?

You don't know what happens if you drop an index covering a pk? Try it 😉

There are a few uses of rCTE's in this thread;

http://www.sqlservercentral.com/Forums/FindPost1202081.aspx

Jeff Moden (3/25/2012)

---

ChrisM@home (3/25/2012)

---

You're right Jeff, although it's faster than generating all rows, it's a "wee bit slower" than this:

SELECT TOP (ISNULL(DATALENGTH(@pString),0)) n = n1+n2+n3+n4

FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t2(n2)

CROSS...

the sqlist (3/24/2012)

---

...Which makes the issue more rhetorical than anything.

Sometimes it is better to keep the things simple in terms of solution and not to think about the effects...

Jeff Moden (3/24/2012)

---

....

Seems like a lot more work than necessary. Wouldn't a modification for 2008 of Itzik Ben-Gan's original code be a little more eye-ball friendly not to mention...

I couldn't disagree more. When you're looking at an overall time of 25ms per run...

the sqlist (3/23/2012)

---

...

I'm lost here. What's wrong with what I posted above?

select

n

from

(

SELECT n = (n1 + n2 + n3 + n4)

FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t3 (n3)

CROSS JOIN (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9))...