Home Forums SQL Server 7,2000 T-SQL Dynamic Query/sproc RE: Dynamic Query/sproc

  • May 8, 2010 at 7:58 pm

    #1164648

    alex abenitez (5/5/2010)

    The Dynamic part is for the creation of the fields.

    Heh... we know that, Alex. How will it be used? I ask because that's a large key to how to do this.

    I'm glad you got it working but I'd still be interested in know the "why" and what you did to solve it. We might be able to make it a wee bit faster (or not).

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