Can a SP input Parameter be an array?
The best way for this in using xml string as a parameter. You can pass to SP
whatever you want in xml and then, in SP, parse this into separate local
Brainbench MVP for Visual Basic
Distribution Systems Lead, Data Systems
> I'm looking for some ideas on how to update, anywhere from 1 to 20
> with the same piece of data (Index number). Currently I'm using a SP and a
> ADO command parameter, running it over and over, until all the target
> records are updated.
> I'm sure that I can build the ADO parameters dynamically but the question
> is, how could I build the Stored Procedure Input Parameter(s) to accept a
> variable number of inputs?
> Should I build 20 Parameters and just not use the remainder, via some
> decision loop?