Hello Guys:
I have a question about a Stored Procedure on SQL Server. What I would like to do is
pass the Stored Procedure an array (or a string seperated by commas). Then, have the
Stored Procedure split that string, and insert each value into the database.
I thought this would be more efficient (one SP to the database, rather than many) than
writing the following code in my ASP Page.
For Lcv = 1 To Request.Form("AppID").Count
SQL = "EXEC storedProcedure @AppID=" & Request.Form("AppID")(Lcv)
objConn.Execute
Next
If I have 15 different applications, I would call the stored procedure 15 times. If I
can get it on SQL server, I would only have to call it once, which should be far more
efficient.
Would anyone be able to give me some advice or direction on how to handle this?
Thanks
Andy
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
