Deleted

Manie Verster (2/23/2010)

---

Jeff Moden (2/22/2010)

---

Manie Verster (2/22/2010)

---

I checked out Grant Fritchey's[/url] article and was, like Jeff, not very pleased to see some while loops but one query attracted my attention...

Jeff,

Thanks for the heads up on the fact that it can be done without tables. I now see the solution. To just generate and count the numbers from...

Jeff,

I don't want people on my team optimizing for trivial things, and the constraints of the project define those things. Speed may not be essential, or it may. ...

Well I have to dispute the scalability of Jeff's implied solution and also think it is clunky and not intuitive. If we are to add scalability and speed as...

Manie Verster,

I notice that you used a temporary table rather than a table variable. Why did you make that choice?

Thank you.

It took me 14 minutes and I developed a solution which turned out to closely approximated one or more of what was on Fritchey's page.

What is wrong with using a...

vfazal,

Thank you! That is exactly what I wanted. Could you tell me how you learned of this method?

Jerry,

Thank you, but I was looking for a method to get...