create procedure y
create table #tmp( empid int, column int)
insert into #tmp
select * from #tmp
select sum(empid) from #tmp
This will work as long as #tmp has the same definition as the result set as x.
(also note if you are returning to an application the program will have to go to the next record set after it reaches the first EOF to pull the data from the next select)