Massive??

[sculptorlv]

Hello again!

I have another "situation for a junior". Hope for help and advises.

I have a sql table, like:

SQL SELECT

ID

Name

Age

etc...

FROM Table

WHERE

Name <> Name1

Name <> Name2

..

Name <> Name50

What is the best practice to define these WHERE expressions? Is it possible to make a massive of all possible "Names", which I will not take in my SQL Select? Also, it might be more comfortable to change and massive rather WHERE expressions..

[Anonymous]

Hi,

You can define all the names which you want to exclude in an excel file, and load that excel in script under one resident,

later use where not exist functionality to exclude.

[sculptorlv]

Got error:

[tresB]

WHERE

RTrim(LTrim(Tbl_Contract.Title)) Not In ($(vFriendCompnayList));

?

[sculptorlv]

Now it works, but the result is the same.

VENDEN KAFIJAS TIRDZNIECĪBA is within the data

[tresB]

Somehow the string is not matching. Try the same in the sql db itself (with the single value). Does it work? Find the exact match in the db itself for that particular title and copy paste it from there to qv. It should work.

[sculptorlv]

For no I use Where name <> Name1 AND name <> Name2 ... it works.

[sculptorlv]

How to make an exclude?

[Anonymous]

using where not exists(FieldName)

[reddy-s]

Hi Ruslans,

Where not Exists() should solve your issue.

Check this out:

The exists issue

[sculptorlv]

Sorry, I don't get it.

I don't need these 'a' values at all, but in the example it got ONE 'a' values from two tables.