Virtual table?

[jararaca]

Is there a way to create a virtual table in a stored procedure that holds the results of a call to another stored procedure?

In other words, say I have sp1. Can I do something like this in sp2:

VirtualTable = EXEC(sp1 param1, param2)

SELECT<field list>
FROM VirtualTable

If so, what is the correct way to do it?

Thanks,

 

[jbenson001]

You can use Insert <table> exec sp(param1, .. etc)

But you first must create the virtual table definition first.

Jim