Why don't you write a stored procedure on SQL Server ?
Something like
create procedure myProc as
declare myCurs cursor for your first select that gets the array
open myCurs
fetch from myCurs into
while (@@fetch_status = 0)
begin
insert into ..
fetch next from
end
Hi everybody,
I use microsoft SQL server, and XSP pages. I also use ESQL for all my DB
commands.
I want to insert data with query like INSERT Into blabla (ID) values
(MyArray)
In this query MyArray is the result of another query. How can I make
it?
Here is an example :
Table : XY
Columns : ID,