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