Load Script

[#1]

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

[sushil353]

Hi,

SQL SELECT AgentId,

    Campaign,

    Duration,

    ID,

    ActionLocalTime,

    SessionID,

    NextState

FROM "HN_Ondata".dbo.ODActions where NextState in ('96','99');

[pokassov · Accepted solution]

where NextState='96' or  NextState='99';

[#4]

Hi Try this

SQL SELECT AgentId,

    Campaign,

    Duration,

    ID,

  ActionLocalTime,

    SessionID,

    NextState

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

thanks

Manju

[#5]

Thank you for the quick reply.

It is working now.

[#6]

Hi Hasvine,

Try this

SQL SELECT AgentId,

    Campaign,

    Duration,

    ID,

  ActionLocalTime,

    SessionID,

    NextState

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

[awhitfield]

Hi Hasvine,

can you please mark the appropriate answer as CORRECT - it helps other community members.

Thanks in advance

Andy

[#8]

Hi Andy,

I do not get the Correct option. I can only see helpful.

Could you please let me know where the option is so that i can change the option.

Thanks,

Hasvine

[sunilkumarqv]

Try this .

SQL SELECT AgentId,

    Campaign,

    Duration,

    ID,

    ActionLocalTime,

    SessionID,

    NextState

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

[awhitfield]

Hi,

You have to open the original thread, then CORRECT will appear 🙂

Andy