Where statement in load script won't work

[#1]

Hi,

I have a where function in the scirpt below. But it don't work. Has you some ideas how to fix this?

The is imported of a mssql server environment.

rept_category_navigation:

Load

//    site as land,

    "super_category_display_name" as super_category,

    main_category_display_name as main_category,

    category_unique_name as unique_name,

    category_hidden,

    super_category_hidden,

    main_category_hidden

from "Reporting_db".dbo."rept_category_navigation"

where((category_hidden='0') OR (super_category_hidden='0') OR (main_category_hidden = '0'));

[marcus_sommer]

'0' is a string - maybe you need it numerical without quotes.

- Marcus

[vgutkovsky]

Shouldn't it be "SELECT" instead of "LOAD"? LOAD is a QV-specific keyword and you're loading from a DB it seems.

Vlad

[IAMDV]

Vlad is right. Looks like you're mixing ANSI SQL code with the LOAD statement. Clearly you're referencing the database name, schema name and object name.

You need somthing like this:

Load *;

SELECT

//    site as land,

    "super_category_display_name" as super_category,

    main_category_display_name as main_category,

    category_unique_name as unique_name,

    category_hidden,

    super_category_hidden,

    main_category_hidden

from "Reporting_db".dbo."rept_category_navigation"

where((category_hidden='0') OR (super_category_hidden='0') OR (main_category_hidden = '0'));