A Strange Comparison

Question

A Strange Comparison

Steve Jones - SSC Editor

SSC Guru

Points: 734444
More actions
October 26, 2020 at 12:00 am

#3793024

Comments posted to this topic are about the item A Strange Comparison

Viewing 10 posts - 1 through 9 (of 9 total)

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

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

Heh... you're such a "NOTty" boy! 😀 I haven't seen syntax like that in a very long time. Lot's of bloody != but incredibly little !< and !>.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Wolfram Kraus SSCrazy Points: 2774 More actions · Answer 2

What is the difference between the second and the third answer?

Bob Razumich SSCrazy Points: 2136 More actions · Answer 3

Wolfram Kraus wrote:

What is the difference between the second and the third answer?

Well, nothing reading the text for both answers. The fact that both answers were used is probably interesting in itself.

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 4

Bob Razumich wrote:

Wolfram Kraus wrote:
What is the difference between the second and the third answer?
Well, nothing reading the text for both answers. The fact that both answers were used is probably interesting in itself.

Heh... the only difference appears to be the different number of people that thought it was a correct answer. 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 734444 More actions · Answer 5

Steve Jones - SSC Editor

SSC Guru

Points: 734444

October 26, 2020 at 9:17 pm

#3801479

Typo and an answer got repeated.

David Conn SSCertifiable Points: 5980 More actions · Answer 6

Interesting.. Didn't even know that this was in T-SQL. I got the answer right because I have programmed in C. Is this just a T-SQL thing or is it standard SQL ( whatever that is ) ?

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 7

I guess you have to read that in English: ! is Not, < is Less, so !< is Not Less than

Great Question!

Regards,Yelena Varsha

BTylerWhite SSCommitted Points: 1569 More actions · Answer 8

Thanks for the question, Steve!

The next question would be, what is the best way to write this for readability? Should we be using "NOT" or flip the operator to use ">". Looking through legacy code, I see "!" more often.

WHERE sd.Profit NOT < 10000;
WHERE sd.Profit > 10000;

David Conn SSCertifiable Points: 5980 More actions · Answer 9

David Conn

SSCertifiable

Points: 5980

November 2, 2020 at 5:55 pm

#3803611

If you flip the operator then it needs to be >=