Hi Conny, An alternative solution is to create a stored function, that does the same thing functionally as the stored procedure, and then call the stored function from a SQL set fields action. This has worked well for me many times
Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Conny Martin Sent: Thu 12/10/09 3:08 AM To: [email protected] Subject: Get result from stored procedure All, Not sure if this is possible, but is there a way to get the results from a stored procedure via set-field-sql into ars. This works in Query-Analyzer declare @p_result int exec SP_TEST 'MDP000000072713', @p_result output select @p_result But in a set-fields-sql $1$ is always null. ARS 7.1p6 MSSQL 2005 W2K3 Enterprise Server Any help is really appreciated. Thanks Conny _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

