CREATE PROCEDURE test
	@somevar INT
AS
.
.
.
.
.
IF (@@ERROR <> 0) BEGIN
	SET @sql = 'EXEC sp_fkeys ' + @table;	
	
        --this is the point where i have no clue anymore...
        --i'd just like to write the results in a TABLE var or something.
        --i have no choice, i have to use this sp (no udf :(...)
        EXEC sp_executesql @sql;

        --at this point i want to continue working with the results...

	END
ELSE BEGIN
	PRINT 'SUCCESS...';
        END;


GO

create table #fkeys
	(PKTABLE_QUALIFIER sysname
	,PKTABLE_OWNER sysname
	,PKTABLE_NAME sysname
	,PKCOLUMN_NAME sysname
	,FKTABLE_QUALIFIER sysname
	,FKTABLE_OWNER sysname
	,FKTABLE_NAME sysname
	,FKCOLUMN_NAME varchar(32)
	,KEY_SEQ smallint
	,UPDATE_RULE smallint
	,DELETE_RULE smallint
	,FK_NAME sysname
	,PK_NAME sysname
	,DEFERRABILITY smallint)

insert #fkeys
exec sp_executesql @sql

DECLARE @table TABLE
(
         PKTABLE_QUALIFIER sysname
	,PKTABLE_OWNER sysname
	,PKTABLE_NAME sysname
	,PKCOLUMN_NAME sysname
	,FKTABLE_QUALIFIER sysname
	,FKTABLE_OWNER sysname
	,FKTABLE_NAME sysname
	,FKCOLUMN_NAME varchar(32)
	,KEY_SEQ smallint
	,UPDATE_RULE smallint
	,DELETE_RULE smallint
	,FK_NAME sysname
	,PK_NAME sysname
	,DEFERRABILITY smallint
);


INSERT INTO @table (EXEC sp_executesql(@sql));