Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is wrong in script from enclosed file?
When I load first script and create a QVD, it is giving me only 2013 until september end data.
But after doing incremental load, I got 2010, 2011,2012 data also.
His incremental load should be starting from 2013?
Data must not appear in previous years?
Yes... I dont want data of Previous Years but when I do the Incremental Load, actually Script picking data from SQL server of previous years also.
What is the meaning of below error code?
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near '00'.
SQL SELECT *
FROM PPMSDB1.dbo."PMS_PURCHASE"
WHERE DECDDT >= 30/09/2013 00:00:00 and RIGHT(PNO,1) <> '4' and RIGHT(PNO,1) <> '3'
Try using the Where condition, as shown in the image below, after the Load statement in the incremental load.
NO... it's not working...
FOR DECDDT i have done one change...
Date(FLOOR(DECDDT),'DD/MM/YYYY') as DECDDT
Hi Manish,
Try the attached app i hope it will solve ur problem.
Regards,
venkat
Try enclosing the date in single quotes and remove the time '30/09/2013'.
And make sure the date for comparison is in the proper format ('09/30/2013' instead of '30/09/2013')
Also for a more robust approach you can use the respective date's number Equivalents (where num(floor(DECDDT)) >= num('09/30/2013'))
Do this:
WHERE DECDDT> = '$ (vMaxDate)' and RIGHT (PNO, 1) <> '4 'and RIGHT (PNO, 1) <> '3'
Dear Venkat,
It's working fine but again taking much time to find Max(DECDDT).
Overall time to add additional data to original QVD doesn't seems to be reduced.
Is there any other way to do the incremental load more fast?
giving me this error.
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Conversion failed when converting date and/or time from character string.
SQL SELECT *
FROM PPMSDB1.dbo."PMS_PURCHASE"
WHERE DECDDT> = '$ (vMaxDate)' and RIGHT (PNO, 1) <> '4 'and RIGHT (PNO, 1) <> '3'