How can I use or command in SQL server?

Question

1.00/5 (1 vote)

See more:

I have used OR command in sql server with select query but it is not working and shows syntax error.

What I have tried:

I had used this query to get data from table.

go
create procedure getpindata(@login varchar(50))
as
begin
(Select Balance_point, ExpiryDate from tblUserPlans where UserID = (Select [AutoId] from [UserDetail] where [UserName]=@login)) or (Select Balance_point, ExpiryDate from tblUserPlans where UserID = (Select [AutoId] from [Emp_Detail] where [LoginID]=@login));
end

Posted 18-Nov-20 20:03pm

Member 14743579

Updated 18-Nov-20 22:55pm

Add a Solution

2 solutions

Solution 1

I have no idea what you are trying to do with that query, but it's never going to work when you try to return multiple values and use them in a conditional statement - you can't say

SQL

(SELECT a, b FROM c) OR (SELECT a, b FROM c)

because it is meaningless.

Sit down and think about your data and what exactly you want to return and under what conditions. Then start thinking about what that means in terms of your DB and SQL.
If you can't work it out, then show us sample DB data, inputs to your SP and the outputs you expect, and explain why you should get those outputs. But at the moment your query is so badly formed that we can't work out what the heck you expect it to do! :D

Posted 18-Nov-20 20:19pm

OriginalGriff

Comments

Member 14743579 19-Nov-20 3:41am

I got the solution, I have used if and else condition in my SQL query.

OriginalGriff 19-Nov-20 3:53am

Excellent!

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)

Richard Deeming · Accepted Answer · 2020-11-18T22:55:00

Solution 2

Try:

SQL

SELECT
    Balance_point, 
    ExpiryDate 
FROM
    tblUserPlans 
WHERE
    UserID = (SELECT [AutoId] FROM [UserDetail] WHERE [UserName] = @login)
Or
    UserID = (SELECT [AutoId] FROM [Emp_Detail] WHERE [LoginID] = @login)
;

Posted 18-Nov-20 22:55pm

Richard Deeming

Comments

Member 14743579 19-Nov-20 6:32am

your query is running very well but I got the solution.