Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SQL SELECT * FROM Periodecomponenten Where cdwerkgever <> '$(Werkgever1)' or cdwerkgever <> '$(Werkgever1)' ;
Hi,
What is your source database. If its oracle, you can use the 'Not in' function instead of the 'or' statement as follows:
SQl
Select *
FROM Periodecomponenten
WHERE
cdwerkgever not in (
'$(WERKGEVER1)' ,'$(WERKGEVER2)','$(WERKGEVER4)','$(WERKGEVER5)')
In this case it's an SQL database.
this should work fine with SQL Server also.
The 'not in' function will work fine with SQL server also
Thank you for your fast respons Haneesh!