8 Replies Latest reply: May 30, 2013 5:15 AM by Jonathan Ditchfield RSS

    SQL Load Script Issue

      Hi,

       

      I have a simple SQL Query which pulls out only two fields from the table updatedb.  The field in particular is called updatetime and it has dates ranging from 03/04/2000 to now.  However from my SQL Script I only to pick up anything greater than 01/01/2008, but when I try and put a where statement in to do just that it ignores the where statement and pulls out all my data.

       

      Attached is a copy of the Query.

       

      The reason I am trying to filter the amount of data from the database, is so that the load script doesnt take ages to run.

       

      Regards,

       

      Jon Ditchfield