9 Replies Latest reply: Jul 29, 2015 9:26 AM by Andrew Whitfield RSS

    Load Script

    Hasvine Dhurmea

      Hello All,

       

      I am actually trying to load data from SQL database:

       

      SQL SELECT AgentId,

          Campaign,

          Duration,

          ID,

          ActionLocalTime,

          SessionID,

          NextState

      FROM "HN_Ondata".dbo.ODActions where NextState='96';

       

      The data are loaded correctly

       

      However, I also want to load the data  where NextState is 99 so I am using the script below and it is not working:

       

      SQL SELECT AgentId,

          Campaign,

          Duration,

          ID,

          ActionLocalTime,

          SessionID,

          NextState

      FROM "HN_Ondata".dbo.ODActions where NextState='96' and '99';

       

      Any idea where I am wrong please?

       

      KR,

       

      Hasvine