3 Replies Latest reply: Mar 11, 2010 12:15 PM by alejandro hernández RSS

    Reducing loading time

      Aftyer spendin a few hours checking in the Forum and the help file, I give up. Can somebody help me with this: I need to load datas from a huge DB. So, in a way to save time in the loading process, and that I don't need all the data's I try to work with the where comand. I try a lot of way to insert this "where" in my script, but no luck in do it work. Here is my script:
      SET ThousandSep=',';SET DecimalSep='.';SET MoneyThousandSep=',';SET MoneyDecimalSep='.';SET MoneyFormat='$#,##0.00;-$#,##0.00';SET TimeFormat='hh:mm:ss TT';SET DateFormat='DD/MM/YYYY';SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';SET MonthNames='Ene;Feb;Mar;Abr;May;Jun;Jul;Ago;Sep;Oct;Nov;Dic';SET DayNames='Lun;Mar;Mi�;Jue;Vie;S�b;Dom';ODBC CONNECT TO [Qlik view Capital Humano] (XUserId is XEPCSCRIXCVB, XPassword is KdKOeSRMXDfB);CAPITAL_HUMANO:LOAD Idregistro, Empresa, EmpFicha as Ficha, EmpFechaingreso, EmpFechaBaja, EmpEstadoEmpleado,.... AsgContrato, FechaActualizacion, DAY("FechaActualizacion") AS [DAY], WEEK("FechaActualizacion") AS [WEEK], Day(FechaActualizacion) & '-' & Month(FechaActualizacion) AS FechaDMI, MONTH("FechaActualizacion") AS [MONTH];SQL SELECT *FROM EDW.dbo.Empleados;Store CAPITAL_HUMANO into cAPITAL_HUMANO_2010.qvd;
      I would like to select some dates from the field FechaActualizacion (imestampFormat) I'm sure about the syntax of the date I want to select. I try this: SQL SELECT * where [FechaActualizacion] = '07/01/2010 12:00:00 a.m.' and where [FechaActualizacion] = '02/02/2010 12:00:00 a.m.' Can somebody tell me how to do it? I will really apreciate any help in solving this isue. Patrick