Post reply

which one is best

  • June 9, 2006 at 12:02 am

    #169158

    hi all,

     

    i need to pass a list of values to a procudure, for that i need to use

    either a commaseparated file or array.

    can any body tell whi approach is best

    nidheesh kuvil

     

     

  • June 12, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • June 16, 2006 at 6:00 pm

    #644442

    I'm pretty sure that you cannot pass an array... guess that leaves a CSV parameter...

    If you don't have very many parameters in the "list", why not pass them as individual parameters?  That would be the best, in most cases.

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

  • June 17, 2006 at 11:49 pm

    #644487

    Hello Nidheesh..

    You should pass your array in an XML document.  You can read a journal article here which describes the technique.

    Hope this helps!  Please write back on my blog (where there are several posts on XML performance) or here if there's anything else you need.

      - Ward Pond

    Take care..

    - Ward Pond
    blogs.technet.com/wardpond

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply