I am stuck with a scenario wherein , i need to fetch data from SQL , wherein my table name changes dynamically every month i.e.
for current month table name is ABC_201908
Next month a new table would be created ABC_201909
So there would be two tables in month of September and requirement is to fetch data from the newest table i.e. ABC_201909.
Note that ABC_ is always constant.
Kindy request you to provide your help for the same