insert into myTab exec myProc

[liuk]

Hi,
i have a (quite complex)stored returning two different set of data (different columns). Now i need to call that stored within another one and insert only the first result set into a table

Insert into myTab
Exec myProc

Is it possible?

 

[vongrunt]

One way: modify sproc to receive optional parameter (code in red represents changes):

alter proc sprocname (@arguments.... [!], @outputs tinyint = 3[/!])
as
set nocount on
...
[!]if @outputs & 1 = 1
begin[/!]
	-- output 1st set
[!]end[/!]
...
[!]if @outputs & 2 = 2
begin[/!]
	-- output 2nd set
[!]end[/!]
go

By default sproc is backward-compatible... but if you call it with @outputs=1 only 1st set would be returned.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[liuk]

thanks vongrunt , that's what i've done!