Curenntly I have a requirement is that I have a huge voume of data i.e around 3 years of data.
In that I want to create QVD for last 6 weeks data.
Can any one help me out in creating the expression for the same.
Thanks & Regards
load * from myqvd
where week(date(datefield)) >=week(max(date(datefield))) -6 and week(date(datefield)) <=week(max(date(datefield)))
load * from qvd;
Where week(TempDate)<= Week(Date(Today()))-6 ORDER BY TempDate ASC;
drop table Master; //if you want then drop it
store Transaction into E:\tansaction.qvd;
here bold one is My Date Field
hope it helps
Retrieving data ...