RE: Inline syntax for indexes

SSC Guru

Points: 1003863

August 11, 2014 at 4:43 pm

GilaMonster (8/11/2014)
Jeff Moden (8/11/2014)
Now that would be nice in "regular" T-SQL.
Err.. It is in regular T-SQL, from SQL 2014 onwards.

I'm so far behind that I'll need to be twins to catch-up. Most of the folks that I've been working with are still working with 2005 and I haven't given a thought to catching up to 2014, yet. Seems like I can't convince them to upgrade, either. Thanks for the info.

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