Insert multiple records w/o select subquery

[cossiboon]

Hello.
Hopefully somebody has an answer to this.

My website imports a list of contacts from a tab delimited file and sets all the data into an array. I then loop through that array and insert each contact using a stored procedure.

I'm curious if there is a way to insert the whole array with one insert statement, but at the same time get the id field generated for each array item.

Anybody?

Here's the ASP code:
for i=0 to ubound(aryList,1)
strQuery = "EXEC Create_Insert_User " &_
"'" & replace(aryList(i,0),"'","`&quot & "'," &_
"'" & replace(aryList(i,1),"'","`&quot & "'," &_
"'" & replace(aryList(i,2),"'","`&quot & "'," &_
"'" & replace(aryList(i,3),"'","`&quot & "'"
set objRUsrID = objCnn.Execute(strQuery)
aryUsrId(i) = objRUsrID("id&quot.value
next

 

[NoCoolHandle]

I am about 99% certain the answer here is NO

(at least not wihtout significant coding wihtin a stored proc and it would probably run slower than what you have now)

HTH

Rob