On 30 Oct 2001, at 12:12, Mike Grover wrote:

> Is it possible to do a select on a stored procedure that
> Insert's a record into a table?
>
> If so, where can I find a example?
>
> thanks, mike

something like this might work

insert into tableA (tableAfieldA, tableAfieldB)
values (select fieldA, fieldB from StorProcA)

(the syntax might not be 100% correct)

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz