3 Replies Latest reply: Feb 28, 2013 1:44 AM by Rob Wunderlich RSS

    How to limit data during first load?

      Hi,

       

      I have this instance that from database, the data I will fetching is more than million of records, and in order to limit the data, I want only to load date that is equal or greater than April 1, 2012

       

      So, this is the syntax:

       

      Load ID,

              DOCDATE,

              ITEMNO;

      SQL Select * from TABLE where DOCDATE >= '4/1/2012';

       

      Is that possible? Say that I am connected to the database that is why I used SQL Select

       

      Thanks for your help!

       

       

      Regards,

      Bill