How to write data to two tables from one procedure?

Question

Stored procedures

Good afternoon.
I have a procedure that returns two different results

create proc Myproc
as
select top 10 * from clients
select top 10 * from Firms

Is there some way I can write both streams to pre-prepared temporary tables, or can I only do it inside the procedure?

Answer 1

You can on the client. NextRecordset Method (ADO) .
How to get 2 tables in a stored procedure in SQL...