Tom.Thomson (6/1/2011)

---

izblank (6/1/2011)

---

Or, suppose you need to calculate sum of squares of consecutive integers. You could do it in a loop, or you could expand your Tally table...

Antares686 (6/1/2011)

Now that said you should never calculate a single employees time sheet in a system. In that scenario you would not calculate anything after the fact because you have...

To Antares686:

The Calendar table is not very big, so you're not saving much space by storing exceptions. Besides, having a full-blown Calendar table gives you much more than just...

Gijs,

in my company, we had to solve a similar problem - given the order date and number of production days, calculate the ship date. We did come up with...