If else statement in sql server

Question

1.00/5 (1 vote)

See more:

SQL

CREATE PROCEDURE [dbo].[K_FS_Test] 
	
	@fromdate datetime,
    @todate	 datetime,
    @customertype varchar(50),
    @customername varchar(50)
	
AS
if(select Orderno from k_Fs_orderdetails where attrited = 'false')

BEGIN
      	
	
	SET NOCOUNT ON;
select orderno from K_FS_OrderDetails where attrited = 'false' AND customertype in (@customertype) and customername in (@customername)
 and ordereddate between @fromdate and @todate
order by orderno desc 
   
END
ELSE	
	BEGIN
	
	select orderno from K_FS_OrderDetails where attrited = 'TRUE' AND customertype in (@customertype) and customername in (@customername)
 and ordereddate between @fromdate and @todate
order by orderno desc 
   
   END

Please correct this procedure...

Posted 11-Mar-14 21:38pm

Siva Hyderabad

Updated 11-Mar-14 21:40pm

v3

Add a Solution

Comments

RAHUL(10217975) 12-Mar-14 3:52am

Can u provide table structure with data? and what error you are facing?

2 solutions

Solution 1

if orderno='love'

SQL

if((select Orderno from k_Fs_orderdetails where attrited = 'false')='love')

Posted 11-Mar-14 21:56pm

King Fisher

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)

thatraja · Accepted Answer · 2014-03-11T22:30:00

Always include the error message in your question to get quick answers.

IIRC you should use the condition like below(IF EXISTS)

SQL

IF EXISTS(select Orderno from k_Fs_orderdetails where attrited = 'false')

Check this one for simple example
Drop Stored Procedure if exist in SQL Server[^]

OR get the value(first SELECT query result) in a variable, use IF condition for that to create conditions

And careful with case sesitive things. Yes, why are you using 'false' & 'TRUE'. Use either lowercase or UPPERCASE for both values. I recommend you to use functions UPPER/LOWER in your query to get right resultset.