Yep... a Numbers or Tally table would do it. You just need to write the simple logic to split dashed-pairs when they occur.

For an explanation of how a Numbers...

Man, I hope that's in good humor... If it's not, I'm really sorry.

Agreed on most... but that doesn't tell us why you feel the need to take a survey on it. Are you trying to justify moving from 2k5 to 2k8?

timothyawiseman (1/23/2009)

---

I cannot possibly agree more....

Man, I blew another pork chop out my nose when I saw the trigger and the cursor.

peter (1/22/2009)

---

Right now I do feel tempted to try and put an article together that analyzes functions more in-depth and demonstrates how to best use them according to my personal...

I'm not sure it was worth storing 43 years worth of numbers (480,000,000/30,000/365) even if (at 6 bytes with no overhead) that works out to be just 2.8 gig. ...

Man, I appreciate your effort, but, heh... the no such thing for me. 😉

Matt Miller (1/23/2009)

---

Jeff Moden (1/23/2009)

---

I'll add another wish... there's a lot of things (not just running totals) that require "looking" at a range of previous or next rows. It...

Matt Miller (1/23/2009)

---

As for me, I would settle for actual, complete, documentation of the new features added as they are added. Functionality changes, "this doesn't work in x version...

JJ B (1/23/2009)

---

Jeff Moden (1/23/2009)

---

I'm good with that... I've used both Oracle and SQL Server... I have to admit that I "cut my teeth" on SQL Server so there's some...

Heh... Ok... Game on! 😉

JJ B (1/23/2009)

---

I appreciate all the ideas posted here. They have re-awakened some of my own itches.

At the same time, looking at these posts has depressed me. I...

anbillava (1/23/2009)

---

I am able to do it by some of other posts in the portal. Thanks for all your info. I am actually working mas data archive and restore stuff....

Goldie Graber (1/23/2009)

---

Nope, it's Goldie. 🙂 I think I'm going to change my user name.

And, thanks... that's one of the posts I...