Create a temp table and insert the results from proc1 into it, do the same for proc2

select from temp table 1 use EXCEPT on the select from temp table 2

In it's most basic form (and no points for cute code, but it should get you going int he right direction):

/* Setting up only so we have data for our procedures as a test ONLY */

create table temp1 (col1 int, col2 varchar(1))

create table temp2 (col1 int, col2 varchar(1))

insert into temp1

select 1,'A' union all

select 2,'B' union all

select 3,'C' union all

select 4,'D'

insert into temp2

select 1,'A' union all

select 2,'B'

go

create proc dbo.getresults1 as

select * from temp1

GO

create proc dbo.getresults2 as

select * from temp2

GO

/* ENd of set up */

/* Here is what you would do */

create table #t1 (col1 int, col2 varchar(1))

create table #t2 (col1 int, col2 varchar(1))

insert into #t1

exec dbo.getresults1

insert into #t2

exec dbo.getresults2

So a simple select from both temp tables show:

And for the other:

Now you can run your EXCEPT

select * from #t1

except

select * from #t2

Which will output the missing rows:

Again, there are MANY WAYS to do you, and this is not pretty or anything, but should get you going in the proper direction