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);