I'm guessing it would actually be used in an OUTER JOIN like in the possible solution I gave~ from what he says the main table doesn't contain saturday/sunday records so he created the calendar for it.

@OP: did you try the code I sent back?