Wt,CargoType,OprType,status,nxtStatus,agencyCode,datecr,actdate,mode,year(datecr) as DL_year,
month(datecr) as DL_Month,dbo.ISOweek_SunToSat(datecr) as DL_Weekno from operationdetail;
Store Operationdelay into Operationdelay.qvd(qvd);
drop table Operationdelay;
I am running this script with different DB and getting some more data from that DB. I am concatenating first script with this one. The issue was when run this second script it reloads only limited data and the QVD size becomes (Around 11 MB). How is it possible whe we use "concatenate" in both DB i have same table with same column name i checked twice. Pls help me to fix this problem.