How to use or operater in sql server

Question

0.00/5 (No votes)

See more:

Hi All,

I have used a query like that.

SQL

SELECT *,convert(varchar,DOJ,103) as DateOJ FROM Registration_Mstr R,Designation_Mstr D,Department_Mstr DP where R.DesgId=D.DesgId and DP.DepartmentId=R.DepartmentId and  EmployeeStatus=1 and (D.Designation<>'Administrator' or D.Designation<>'Directors') order by EmployeeName

In this I do not want to populate information of employees whose designation are Administrator and Directors.
But still it is showing information.
Please help if I am wrong somewhere .

Thanks
Mohd. Wasif

Posted 5-Sep-11 2:05am

Mohd Wasif

Add a Solution

3 solutions

Solution 2

Don't use OR. Use AND only. D.Designation<>'Administrator' AND D.Designation<>'Directors'

Posted 5-Sep-11 2:11am

Toniyo Jackson

Comments

Monjurul Habib 5-Sep-11 14:59pm

nice advice, but "NOT IN" is better..my 5

Solution 3

Another way of saying this in SQL is to use IN-lists. They may sometimes be more easy to interpret:

SQL

SELECT *,convert(varchar,DOJ,103) as DateOJ 
FROM Registration_Mstr R,
     Designation_Mstr  D,
     Department_Mstr   DP 
where R.DesgId        = D.DesgId 
and   DP.DepartmentId = R.DepartmentId 
and   EmployeeStatus  = 1 
and   D.Designation   NOT IN('Administrator','Directors') 
order by EmployeeName

Posted 5-Sep-11 2:13am

Wendelius

Comments

Monjurul Habib 5-Sep-11 14:57pm

yes NOT IN is better..my 5++..proposed as best answer.

Wendelius 5-Sep-11 15:03pm

Thank you.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Accepted Answer · 2011-09-05T02:08:00

Solution 1

You need to use and

SQL

D.Designation<>'Administrator' or and D.Designation<>'Directors'

Posted 5-Sep-11 2:08am

Prerak Patel

Comments

Toniyo Jackson 5-Sep-11 8:11am

You beat me to it. 5!

Prerak Patel 5-Sep-11 8:13am

Thanks TJ :)

Mohd Wasif 5-Sep-11 8:13am

Thanks Dear
My +5

Prerak Patel 5-Sep-11 8:14am

You are welcome. If your query is solved, mark the answers.

Monjurul Habib 5-Sep-11 14:59pm

nice advice, but not in is better..my 5