# Getting return value from MSSQL Execute Action?

**URL:** <https://www.finalbuilder.com/forums/t/getting-return-value-from-mssql-execute-action/7247>\
**Category:** Discussion\
**Created:** [June 30, 2022, 4:52pm UTC](https://www.finalbuilder.com/forums/t/getting-return-value-from-mssql-execute-action/7247 "2022-06-30T16:52:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jonathanmeltzer](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/34f0e0/32.png) [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\
**Post date:** [June 30, 2022, 4:52pm UTC](https://www.finalbuilder.com/forums/t/getting-return-value-from-mssql-execute-action/7247/1 "2022-06-30T16:52:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jonathanmeltzer](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/34f0e0/32.png) [@jonathanmeltzer](https://www.finalbuilder.com/forums/u/jonathanmeltzer)\
**Post date:** [June 30, 2022, 7:52pm UTC](https://www.finalbuilder.com/forums/t/getting-return-value-from-mssql-execute-action/7247/2 "2022-06-30T19:52:49Z")

</div>

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.