Re: Recordset Returned via Stored Procedures

[pmeidingerParticipant]

Hello,

For the sake of argument, let’s say my stored procedure has no input or output parameters and is just a SELECT statement:

CREATE PROCEDURE dbo.sp_GetBuildingList AS

BEGIN

SET NOCOUNT ON;



SELECT building, name

FROM dbo.buildings

ORDER BY name

END

How do I set up the Connection Action to receive the ‘building’ and ‘name’ fields from the stored procedure? I tried adding Return Parameters (screenshot here: http://i.imgur.com/ZPHZE.png) but I get an error:

ERROR

Agent SQL error

Procedure sp_GetBuildingList has no parameters and arguments were supplied.

How do I get those two rields back from my stored procedure?