Re: SQL Date function question

On Jul 8, 2011, at 9:38 AM, midrange-l-request@xxxxxxxxxxxx wrote:

With so few acknowledgments on the use of calendar files, I was often
left wondering if the need to JOIN to a calendar file somehow was a
turnoff for many.

I think you are right. We've all been conditioned by "don't create too many tables" and even more to "Don't create too many logicals/indexes". For the most part the rationale behind these beliefs is long-since gone but it is hard to force them out of our brains. When I first came upon this I thought that it would be inefficient - but then saw how much easier the code was to understand and discovered that the performance was not an issue (particularly when compared with 2 or three nested function calls) and decided to give it a try.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com