Hi Friends,
i have a requirement like, in SQL database we have 4 lakhs of records that consists last 30 days info.
from PI at first poll interval we need to fetch the current date - (minus) 30th day records
at second interval we need to fetch the current date - (minus)29th day records
current date - (minus) 28th day records
like wise i need to fetch up to current date - (minus) one day records.
NOTE: there is no flag field to update.
please provide any suggestions to achieve the same.
Regards,
Janardhan