It's possible to create the procedure that returns recordset. It could be used instead of select. That's fine. But can it be used in another procedure or in insert from select statement?

insert into t
call prc