Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a table where it has data for last 6 months . I need data which has last month data only.
for example i have 10 values in may month and 10 values in June month .
I need to get only June month values as 10 from the table.
Can anyone help me out how to bring that values from load script.
The field name used in the table is monthly refresh
First load the date field and store the max month into a variable vMaxMonth.
Then load the data for that month only.
Data:
Load
----
----
From -----
where Month = '$(vMaxMonth)'