• Not actually my article, but one I found.

    The idea behind it is to incur a single , perhaps large, set-up cost and from then on just use the set-based capabilites that SQLServer is designed for.

    Thanks for other the observations , will take them into consideration next time I implement one of these auxiliary calendar tables

    cheers