9 Replies Latest reply: Oct 29, 2015 12:53 PM by Imran Khan RSS

    SQL Command not ended properly error

    Mark Graham

      Hi all,


      I have a filed "Updated TimedAte" in my qvd

      I wanna do incremental update using this filed but i was not able to .





      LOAD max(Timestamp((LAST_UPDATE_DATETIME)) as maxdate FROM 1.qvd (qvd);



      LET vInc = 'WHERE Datetime(LAST_UPDATE_DATETIME) >=' & Peek('maxdate');



      SQL Select * from Table where Last Updated Date Time >= $(vInc);