ScottPletcher (6/6/2013)

---

Sorry: middle value.

So, if the values were 10, 50, 100: 10 is min, 100 is max, 50 is mid.

Sean Lange (6/6/2013)

---

MID?

Sean Lange (6/6/2013)

---

You in Kansas too?

Lynn Pettis (6/6/2013)

---

I have written it manually so many times I have it committed to memory.

Sean Lange (6/6/2013)

---

But what do you mean by "But then the iztec way avoids disk reads"? Do you mean by creating the tally table on the fly?

Sean Lange (6/6/2013)

---

iztec?

Dird (6/5/2013)

---

I don't have to create this every time I need to use it. I keep it as a permanent table at all times.

Simpler code and no RBAR (hidden or explicit)

WITH CTETally(n) AS(

SELECT TOP 100 ROW_NUMBER() OVER( ORDER BY object_id)

FROM sys.all_columns

Lynn Pettis (6/5/2013)

---

Actually, something more like this:

Luis Cazares (6/5/2013)

---

You'll be surprised, but programming isn't something you can just learn in books, it requires special learning capabilities.

Dird (6/5/2013)

---

I would say that is a loop. A tally table can do this quite easily though.