Hey guys first thanks for all the replies. A calendar table was not something I considered before but I'll for sure take a look at that now. I can't really...
Sorry guys I should have given more details. Hopefully this post will provide better information. Ignore the table names lists above in my op. The whole point of this is...