Home Forums Article Discussions Article Discussions by Author Discuss content posted by Randal Burke Faking Multidimensional Arrays in T-SQL made easy! RE: Faking Multidimensional Arrays in T-SQL made easy!

  • November 4, 2008 at 12:52 pm

    #893833

    stax68 (11/4/2008)

    Jeff Moden (11/4/2008)

    Nah... not true... in SQL Server 2005 and up, there's basically no limit to passing arrays...

    http://www.sqlservercentral.com/articles/T-SQL/63003/

    The author just didn't go far enough in showing how to use the EAV tables he made in his examples as a 3 dimensional array. Most people blow a couple of gears for anything above a 3 dimensional array so 3 dimensions is a good place to stop. People that need more than that will be able to figure it out quite easily.

    Randal, nice job at "standing" up an array in "memory". It's a simple concept that far to many folks have forgotten and some have never learned. It's good to see it in print.

    Hello Jeff M?

    Any explanation of the above forthcoming?

    Heh... you gotta be more patient... I actually work for a living, ya know? 😛

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