Query -- Help

Question

Query -- Help

Minnu

SSCertifiable

Points: 6451
More actions
December 17, 2013 at 7:12 am

#287495

Hi Team,
Please help in below query, it should return TRUE.
DECLARE @req_1 varchar(50)
DECLARE @req_2 varchar(50)
set @req_1='AAM'
set @req_2='VVE'
if (@req_1 !='AAM' OR @req_2 !='VVE')
print 'TRUE'
ELSE
print 'FALSE'

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

Minnu (12/17/2013)
Hi Team,
Please help in below query, it should return TRUE.
DECLARE @req_1 varchar(50)
DECLARE @req_2 varchar(50)
set @req_1='AAM'
set @req_2='VVE'
if (@req_1 !='AAM' OR @req_2 !='VVE')
print 'TRUE'
ELSE
print 'FALSE'

What is the business rule you are trying to achieve here? Look at your logic..

Both conditions are false.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

onlygoodones SSC Eights! Points: 870 More actions · Answer 2

-- Not sure what the Business requirement is but for you to get the output as TRUE, use this:

DECLARE @req_1 varchar(50)

DECLARE @req_2 varchar(50)

set @req_1='AAM'

set @req_2='VVE'

if (@req_1 ='AAM' OR @req_2 ='VVE')

print 'TRUE'

ELSE

print 'FALSE'

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Or maybe this...

if (@req_1 !='AAM' AND @req_2 !='VVE')

print 'TRUE'

ELSE

print 'FALSE'

It all depends on what you are trying to do here.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Alan Burstein SSC Guru Points: 61141 More actions · Answer 4

Minnu (12/17/2013)
Hi Team,
Please help in below query, it should return TRUE.
DECLARE @req_1 varchar(50)
DECLARE @req_2 varchar(50)
set @req_1='AAM'
set @req_2='VVE'
if (@req_1 !='AAM' OR @req_2 !='VVE')
print 'TRUE'
ELSE
print 'FALSE'

It's worth noting that you should replace the non-standard syntax: != with <>.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001