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
Th
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 :
