I want to load last two months data into my application. I just want to create a table which should stores the last two month names in below format. Say for example I have a variable called "vEndingMonth" and the month name stored as "Sep 2015". I want to create a table (by using the above variable) which should contains below month names.
I'll use the above table when loading QVD's. I wish to use direct file names in my load script instead of looping through all QVD's.
There are multiple ways to achieve this. Let me suggest one way..you can create two columns like prev_month, prev_month-1 and with addmonths() function you can substract -1 for previous month and -2 for previous to previous month. with Date# function you can get the desired format..