t-sql query

Question

t-sql query

Viewing 7 posts - 16 through 21 (of 21 total)

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

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

Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.

I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉

--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)

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 2

Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.
I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉

Good idea! I will start doing it as well. Just, insisting everyone using "!=" instead of "<>" as I do like it more and I have a powers to reject the code... :hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

CapnHector SSCoach Points: 16143 More actions · Answer 3

Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.
I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉
Good idea! I will start doing it as well. Just, insisting everyone using "!=" instead of "<>" as I do like it more and I have a powers to reject the code... :hehe:

Am i right in how i see "!=" and "<>", i see them as slightly different. != is and explicit "Not Equal" where as "<>" Is "Less Than or Greater Than" Functionally the same but personally prefer the explicit "Not Equal" if that is what i am after.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 4

capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.
I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉
Good idea! I will start doing it as well. Just, insisting everyone using "!=" instead of "<>" as I do like it more and I have a powers to reject the code... :hehe:
Am i right in how i see "!=" and "<>", i see them as slightly different. != is and explicit "Not Equal" where as "<>" Is "Less Than or Greater Than" Functionally the same but personally prefer the explicit "Not Equal" if that is what i am after.

We can be united into political party now! Any good name? What about "Exclamation Equality Party"

(EEP - Eugene Elutin's Party :-D)

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 5

capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.
I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉
Good idea! I will start doing it as well. Just, insisting everyone using "!=" instead of "<>" as I do like it more and I have a powers to reject the code... :hehe:
Am i right in how i see "!=" and "<>", i see them as slightly different. != is and explicit "Not Equal" where as "<>" Is "Less Than or Greater Than" Functionally the same but personally prefer the explicit "Not Equal" if that is what i am after.

That's when I break out the next line of defense. "Sure, you're entitled to an opinion on this. Your code still won't pass, though."

--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)

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 6

Jeff Moden (5/1/2012)
capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.
I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉
Good idea! I will start doing it as well. Just, insisting everyone using "!=" instead of "<>" as I do like it more and I have a powers to reject the code... :hehe:
Am i right in how i see "!=" and "<>", i see them as slightly different. != is and explicit "Not Equal" where as "<>" Is "Less Than or Greater Than" Functionally the same but personally prefer the explicit "Not Equal" if that is what i am after.
That's when I break out the next line of defense. "Sure, you're entitled to an opinion on this. Your code still won't pass, though."

I'm not so polite. My version would be shorter: "Go and change to what I've said"!

(I may also add something along the following line: "It's not a parliament here, so I don't *ng care about your opinion". No, to long I guess) :hehe:

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

CapnHector SSCoach Points: 16143 More actions · Answer 7

Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
capn.hector (5/1/2012)
Eugene Elutin (5/1/2012)
Jeff Moden (5/1/2012)
Phil Parkin (5/1/2012)
Eugene Elutin (5/1/2012)
...
Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).
...
I prefer to use "!=" over "<>". Is any reference material where it is "not recommended"?
BTW, that is standard for C-kind of languages
Check out this link.
The fact that it is non-ISO and <> is was enough to sway me. The 'not recommended' comment was purely my opinion, based on this fact.
I tell people it's "not recommended" all the time. When they ask "Why?", my answer is "Because I won't let it through on your code review so you might as well get used to not using it now." 😉
Good idea! I will start doing it as well. Just, insisting everyone using "!=" instead of "<>" as I do like it more and I have a powers to reject the code... :hehe:
Am i right in how i see "!=" and "<>", i see them as slightly different. != is and explicit "Not Equal" where as "<>" Is "Less Than or Greater Than" Functionally the same but personally prefer the explicit "Not Equal" if that is what i am after.
That's when I break out the next line of defense. "Sure, you're entitled to an opinion on this. Your code still won't pass, though."
I'm not so polite. My version would be shorter: "Go and change to what I've said"!
(I may also add something along the following line: "It's not a parliament here, so I don't *ng care about your opinion". No, to long I guess) :hehe:

since were now quite off topic ill say i like Eugene's second (Following Line).

for me as long as its clear before i send my code in for review what is wanted i follow until i can set the rules.

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]