Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
Got error:
WHERE
RTrim(LTrim(Tbl_Contract.Title)) Not In ($(vFriendCompnayList));
?
Now it works, but the result is the same.
VENDEN KAFIJAS TIRDZNIECĪBA is within the data
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.
For no I use Where name <> Name1 AND name <> Name2 ... it works.
How to make an exclude?
using where not exists(FieldName)
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.