that's why I always include duration as a valuable test... it takes into account both CPU time and Disk Time. Of course, I list those, as well... good to...

Florian Reischl (4/13/2009)

---

Don't say that. There might be actually two business cases where...

Aaron N. Cutshall (4/13/2009)

---

Jeff Moden (4/13/2009)

---

Heh... I'm just glad I'm not the only old fart on this site. My first "program" was on unit record equipment that used a...

aktikt (4/13/2009)

---

Say it ain't so. This is the first I've heard a set based solution losing to RBAR.

I don't have the desire to check right now, but what about using...

Thanks for the great feedback on this, Wayne. I wish more people felt like you about this type of thing. Too many folks just want code.

RBarryYoung (4/13/2009)

---

Jeff Moden (4/13/2009)

---

Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of a...

andrew gothard (4/13/2009)

---

Gift Peddie (4/11/2009)

---

andrew gothard (4/11/2009)

---

but I don't foresee the day when "one language to rule them all" will ever come into being. quote]

Isn't that what ADA was...

Heh... you may be right. Might also have to...

Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of a Tally table split...

Flo... there's a small error in your temporary stored procedure. It was leaving a leading space in the results. I've repaired it in the following but it still...

Jeff Moden (4/12/2009)

---

ORDER BY on unindexed Tally table, for...

Sratch the above... I found the index. Still looking.

ORDER BY on unindexed Tally table, for starters. ...

Paul White (4/12/2009)

---

Jeff Moden (4/12/2009)

---

...That brings me to another subject... I hate deprecation. Who is it to say that certain features are no longer useful? The masses? ...

Understood... I used to say "Never" use a cursor. Don't get me wrong, I always try to avoid it and have been very successful at doing so. But,...