nested insert?

Can this be done? a nested instert in a trigger or stored proc?Explain|||Originally posted by ispaleny
Explain
I need to insert several checkbox responses into a table, but the only thing that I can think of doing is using a trigger that will will do an insert ofr the first record and then trigger another insert for the next record. But I cannot find anyone on the web that seems to know if that can be done... please let me know or give a little example of how this coul dbe done. thanks

greg|||??
You have several pieces of data in the front end that you want to get into a database - one piece of data per record?

If you insert the first and use a trigger for the rest how is the database going to know what data to insert - it only knows about the datat for the record inserted.

Easiest is to call the insert SP several times from the front end - once for each record - maybe in a transaction.

You could also send a csv lst to the sp in one call and have the SP then do all the inserts.