Formatting the date

Question

Post reply

Formatting the date

Viewing 6 posts - 31 through 35 (of 35 total)

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

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

In MS Word...

{Edit}{Paste Special}{Unformatted Text}

--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)
Intro to Tally Tables and Functions

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 2

Kenneth Wilhelmsson (10/29/2007)

I was merely pointing out that the blunt statement of 'this is wrong', was missing the context of what was wrong with it. For beginners, they may believe that there was something wrong in a query like that, or entirely missing the point of the (unspoken and not written) intention that was implied.

It's a pretty common 'mistake', when one wants to order by a certain way, but inadvertly orders by 'wrong datatype', so the end result isn't the expected one.

We should take care and explain *why* something is considered 'right' or 'wrong'... 😉

/Kenneth

I didn't need to explain why except for those that took it out of the context of the thread 😉

--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)
Intro to Tally Tables and Functions

Sergiy SSC Guru Points: 110192 More actions · Answer 3

Jeff,

At the end of the day you agreed with Kenneth.

You said that result was ordered wrong way because of wrong query.

Exactly as Kenneth stated from the very beginning: it's the question (query is a question, right?) what is wrong. Answer is write for the question asked.

"I want to be white, cool and I want all women undress in front of me".

Do you know what wizard turned him into?

D)

_____________
Code for TallyGenerator

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

Yeh... 2nd mistake today... 😉

--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)
Intro to Tally Tables and Functions