Is there possible two fill table with second result set returned by stored proc.For instance
create proc test
as
begin
select *from orders

select *from Employees
end

insert into sometable exec test

So I want to fill table 'sometable' with result set
'select *from Employees'. There by tables 'sometable' and 'Employees' have same shema

CREATE TABLE #FileList (Files varchar(8000))
INSERT #FileList (Files)
EXEC master.dbo.xp_cmdshell 'dir c:\'

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

I don't understand. You called proc to fill table.That is ok but as I said I have one procedure wich I can not change, then that proc returns two sets, then I need second set for some calculations in my proc, then I need data from exactly that procedure wich returns two sets.

Sorry joxa83 -- I must have misunderstood the problem. You could call it from a client app, get the second result set and then insert that data into a table.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

That is the problem I have one procedure wich I can not change, then that proc returns two set, then I need second set for some calculations in my proc, then I need data from exactly that procedure wich returns two sets

Forgot to say I can not use front end app.

i don't think there is a way because the two resultsets return different field layouts.

yes sets have different shemas but there must be a way.

I am not sure why you would want to combine the two. But I recall I once came up with an obscure need for this. I created a column called RS for result set. Set the value to one for the first result set, to two for the second. added the two result sets together increasing the columns. For example say I do the following two selects.

Select firstname, lastname from x
Select city, state from y

the result set would come out like this.....

rs FirstName LastName City State
1 John doe
1 Susan Smith
1 Pewee Herman
1 Dubya Bush
2 Hollywood CA
2 New York NY
2 Oklahoma City OK
2 Seattle WA



Notice for RS = 1 there are not city or state values, and for RS = 2
there are no names.

You can do this with a temp table probably easiest.

Hope this helps,
Rob

Nice solution.Thank You.