Getting return value from MSSQL Execute Action?

Automise Discussion
1

If you run something in the MSSQL Execute action, is there a way to capture values returned by the SQL that is run? If you run a Stored Procedure or a Function in MS SQL, there can be a return value…but the Output in the Log in Automise does not contain that value. Is there a way to get a value back to store in a variable that can be used later in the action list? I tried using the Output Monitor to log output to a variable, but that just logged the output of the Automise action, not anything that was returned from it.

Is there another action I should use in order to accomplish this?

Thanks,

Jonathan

2

I just tried the ADO Execute Stored Procedure action, which took a bit to get a handle on, but seems to be doing what I want to do.