Home Forums SQL Server 2005 SQL Server 2005 General Discussion Advice for array oflarge arrays RE: Advice for array oflarge arrays

  • November 24, 2008 at 6:18 am

    #902407

    I'm getting ready to go to work, so I can't solve it all right this instant.

    I do have a question, though... are all of these values for a single column even though the data brings them in 3 at a time? In other words, would it be convenient to bring them into a table that looks like this?

    BlockNum Data

    And, if so, what should the column names actually be?

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