Wayne West (5/7/2008)

---

Excellent article, Jeff! I came across an interesting date table article on Tech Republic that was linked here yesterday after it re-surfaced at BuilderAU.Com.au, I updated the...

Steve Rosenbach (5/7/2008)

---

Jeff, once again, you are my hero!!

Beautifully-written article about such a useful topic.

I've used a "dates" table for quite a while, and actually have a tally table in...

RyanRandall (5/7/2008)

---

If you're not using SQL 2005, I guess you could simulate ROW_NUMBER like this...

declare @param...

Hugo Kornelis (5/7/2008)

---

buktseat (5/7/2008)

---

This is probably a rediculous question, but how can any of your "using the tally table" examples work if you don't declare N? I guess I...

GSquared (5/7/2008)

---

Excellent article, Jeff. Good introduction.

I've been using Numbers tables for a couple of years now, and I just keep finding more uses for them all the time.

Examples include:...

JohnG (5/7/2008)

---

As always, a great article from Jeff.

As for performance testing of various techniques by anyone, I am continually amazed as to the incorrect methods for generating sample data.

Example (taken...

GSquared (5/7/2008)

---

I ran some speed and load tests on this code.

Summary: While the CTE works, and is fast by any normal standard, the Numbers version is even faster, and requires...

GSquared (5/7/2008)

---

Hugo:

Just SP is fine (though I personally dislike the habit - as if anything other than a stored procedure might follow an EXEC keyword). It's SP_ (with an...

Carl Federl (5/7/2008)

---

From the article, you wrote " Tally table .. starting at 0 or 1 (mine start at 1)"

There are advantages for having the Tally table include 0...

Marius Els (5/7/2008)

---

:smooooth: This is slick...... Great work Jeff!

This is a great example of implementing set-based programming, three thumbs up from me.

Now to apply this to problems going forward!

Thanks for...

Mike DiRenzo (5/7/2008)

---

This is a super cool article. Let me repeat, this is a super cool article. What a refreshing read!

I look back on all the TSQL...

Carl Federl (5/7/2008)

---

Another great article ! Thanks

The first reference for a tally table that I can recall is in "Guide to Sybase and SQL Server" by C. J. Date...

chris (5/7/2008)

---

How about using recursion :hehe: to replace loops? (One of the great new functions in SQL2005)

No need for a tally or temporary tables.

Heres a params example:

DECLARE @Params varchar(8000)

SET @Params...

karthikeyan (5/7/2008)

---

Jeff,

Excellent Article!

It seems that you have written for me at the right time.:) Really, It is very useful for me.

Because so far i have replaced more than 5 cursors...

Thanks for the compliment, Chirag.

Yeah, they do have some neat uses on that particular link. It's very strange...