Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-14 : 22:38:36
|
Aaron writes "Hi Sean
From an ASP page I have to insert a variable amount of rows into a SQL 7 table. I have to write an "Employee_ID" and an "Employee_ID_Match" to a table via a Stored Procedure. The problem is there could be up to 300 "Employee_ID_Match" records to insert for each Employee_ID(amount depends on the user selection).
I am holding the records in a VB Array and passing that to the stored procedure.
Q: Is there any way to pass all records to the stored procedure at one time and let it do the bulk insert?
At the moment I have to call the stored procedure from code for each record in the Array. Due to there being up to 300 records for each individual Employee this can cause a significant performance drop.
I hope you can help me as I am desperate!
Cheers
Aaron" |
|
|
|
|
|
Bulk Inserts into table via Stored Procedure