> So far the closest solution I have come up with involves creating a dummy
> table that contains a long list of dates that I can JOIN against in order
> to fill in the interpolated values. It doesn't work very well, and gets
> slow with large tables.
Looks to me like the perfect candidate for a Set Returning Function.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc