Wrapping 2 stored procedures into a select statement

[SteveMe]

Exec checkk 'enrgy80'
Exec checkk 'enrgy46'


I need the records from this stored procedure into one dataset via a select statement

 

[jbenson001]

How do you want to call the SP, in QA, or from a front end app?

Jim

 

[SteveMe]

In QA

 

[gmmastros]

You should create a temp table that has the same structure as the data returned from the stored procedure, then Insert exec from the stored procedure.

Create Table #Temp(Field1 DataType1, Field2 DataType2)

Insert Into #Temp Exec Checkk 'enrgy80'
Insert Into #Temp Exec Checkk 'enrgy46'

Select * from #Temp

The syntax may not be perfect, but the process is the way to go. Check Books on line for more information.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00g7.asp

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SteveMe]

gmmastros I get an error when trying that

Server: Msg 8164, Level 16, State 1, Procedure Checkk , Line 29
An INSERT EXEC statement cannot be nested.

(0 row(s) affected)

 

[SQLDenis]

Did you put this code

Insert Into #Temp Exec Checkk 'enrgy80'
Insert Into #Temp Exec Checkk 'enrgy46'

into the Checkk proc? This will create an infinite loop
You have to put it into a seperate proc

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/