SP that will insert multiple rows

#1

Hello,

Does anyone have an example of a SP that will take a comma separated list of
parameters and for each one insert into a table?

Basically I need to pass in multiple users and the item they need to be
associated with.

Thanks,

Jon

#2

Check out http://www.sommarskog.se/arrays-in-sql.html for techniques to pass
arrays.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Jon" <Jon (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hello,

Does anyone have an example of a SP that will take a comma separated list
of
parameters and for each one insert into a table?

Basically I need to pass in multiple users and the item they need to be
associated with.

Thanks,

Jon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SP that will insert multiple rows

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

SP that will insert multiple rows - 12-22-2004 , 07:13 AM

Re: SP that will insert multiple rows - 12-22-2004 , 08:00 AM