Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Re-posted
Thanks i will try this. The other question i had was - how do i create the history data to monthly QVD files. For instance, how do i create the loop to look at the history and export month by month to qvds for 4 years.
Will this script work for that?
MyQvd:
LOAD *, Date(Date,'YYYYMM') as YearMonth
FROM
source.qvd
(qvd);
Temp:
Load Distinct YearMonth
Resident Temp;
let Vm=NoOfRows('Temp');
for I=0 to $(Vm)-1;
LET vFileName=Peek('YearMonth',$(I),'Temp');
Table:
NoConcatenate
Load * resident MyQvd
where YearMonth = '$(vFileName)';
STORE Table into $(vFileName).qvd (qvd);
drop table Table;
NEXT I;
DROP Table Temp, MyQvd;
see this
Using this you can create the day wise qvds and further you can create the Monthly qvds using daily qvds
Is it possible to do this from the SQL DB and not from a QVD - so far i can only see how people do it from existing QVD's, i want to it from the DB