Ad
  • Custom User Avatar

    You could do a recursive CTE by passing the start date and stopping at the end date (with the where clause), with the other fields being null or zero (with their castings). Then, just do a union all with the results of this CTE and the original table in the target query. Bingo! The blank months will be there.

  • Custom User Avatar

    Just curious, how would you expand the query to include months with no payment information in the output?