Validate Date

Question

Validate Date

Viewing 3 posts - 16 through 18 (of 18 total)

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

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

rbarryyoung (7/11/2008)
Jeff Moden (7/11/2008)
rbarryyoung (7/11/2008)
this was never possible with the old syntax
That's not true...
Hey, I just realized... This is the post that you broke 10,000 on! :w00t:
Woo, hooo! Makes becoming an MVP pale by comparision... hey where is everyone?...
Oh yeah, its Friday night. oh well,...

Heh... it's nice that someone noticed... it does take some bit of dedication as you well know. Thanks, Barry! 🙂

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

Jeff Moden (7/12/2008)
SELECT yada-yada FROM sometable1, sometable2, sometable3 WHERE sometable1.somecol *= sometable2.somecol --Left Outer Join
AND sometable1.somecol = sometable3.somecol --Inner Join

Right, now I may be wrong, I was never a whiz with the old syntax, I was only ever one of the application developers we like to complain about now. But, as I recall, you could not mix these two. Once the "*" appears the query parser would flag the join as "Outer" and that was it: it was an outer join no matter what. And mixing condition types likes you have here just resulted in warnings, (or else it ignored it silently).

As I recall, this was both how SQL Server worked and the ANSI standard. Now as I said, I could be wrong, I was just taking the word of other folks whom I saw as SQL experts way back then (apprx 10 years ago). Does anyone have an environment that they can test it on?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 3

It was at least that long ago for me as well... and I could also have a failing memory ...

I guess the good thing is... we don't have to do it that way no mo'! :w00t:

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