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

    How to limit data during first load?



      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,



      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!