Resultset From Proc As Inline View?

Hi!
I have some stored procedures returning resultsets.

You can store this resultset in an table (table variable, permanent table or temp. table),
but this would require additional code, which has to be maintaned
when called code is changed (typical added columns in resultset).

I would like to avoid this, if it can be done with minimal overhead.

I looked at openrowset/openquery (I looked for something similar to the "THE"-operator), but couldn't find an solution.

Suggestions welcome.


Here some examples showing the idea:

CREATE PROC tmpA

AS

BEGIN

SELECT CAST(42 AS INT) b;

END;



-- 1. can't work

select b from (exec tmpA);

-- 2. cant't work

select *

into tmp

(exec tmpA);



-- 3. will work

declare @a table (a int);

insert into @a

exec tmpA;

select * from @a;