Jeff Moden (11/5/2013)
Phil Parkin (11/5/2013)
Dwain does it again - nice article sir!
Ditto that! Nicely done, Dwain. Great explanations and revelation of code.
I'll second that - and give credit where it's due.
"A friend named Chris Morris once suggested that when writing SQL: “Make it work, make it fast and then make it pretty.” Truer words were never spoken, unfortunately I see a lot of people skipping the last one or two steps. Nicely formatted SQL, with consistent indentation, is much easier for the ordinary mortal to process and understand. I really hate it when I have to wade through what I’d call “stream of consciousness” or write-only SQL. This is when it is appropriate to reinstate firing squads as appropriate punishment."
Credit to Jeff for the original quote, which I've been using ever since it was posted here on ssc - and to you Dwain, for the explanation.
A coworker on a very recent gig wrote only step 1 "expert beginner" code. Truly awful code from a "closed-ear" expert. Apart from that particular idiot and the PM who didn't give a damn, folks are generally very sympathetic to the suggestion - more so if they've had an opportunity to maintain code written with this little gem in mind.
[font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]
For better assistance in answering your questions, please read this[/url].
Understanding and using APPLY, (I)[/url] and
(II)[/url] Paul White
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]