RE: Is It Time To Clear Out Those Quirky Functions?

SSC Guru

Points: 1003861

July 14, 2014 at 3:48 pm

Andy Warren (7/11/2014)
Jeff, did I just see you plug for Access?:-)

Heh... not quite. I figure if even lowly Access can have an incredible and easy to use PIVOT function, why not SQL Server?

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