In this post, we will see how to resolve SQL: Generate Record Per Month for 1st of every month In Date Range Question: I have below source table – TEST_TAB DP_AD_ACCT_NBR DP_AD_CCY_CDE DP_AD_CURR_BAL DP_AD_LST_MDFSN_DATE 10001 REL123 100 2014-11-18 10001 REL123 ...