which one is best

Question

which one is best

nidheesh

Newbie

Points: 2
More actions
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

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

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

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

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)
Intro to Tally Tables and Functions

Ward Pond SSC Eights! Points: 999 More actions · Answer 2

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