Thanks to everyone for your responses. Craig has the answer 'cos I'm used to using calendar tables. But I do like Autos cte as well - it's self-contained.
I appreciate your efforts and I will endeavour in future posts to make my questions un-ambiguous and as clear as possible.
You've made my day easier so I wish you all a good day too.