# Stored Procedure Inside Expression Item

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-inside-expression-item/9285>\
**Category:** Ignition\
**Created:** [November 4, 2014, 6:30pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-inside-expression-item/9285 "2014-11-04T18:30:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Polynomial](https://avatars.discourse-cdn.com/v4/letter/p/848f3c/32.png) [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\
**Post date:** [November 4, 2014, 6:30pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-inside-expression-item/9285/1 "2014-11-04T18:30:34Z")

</div>

Hello,

I’m trying to execute a stored procedure inside of a Triggered Expression Item in a standard transaction group but I keep getting Evaluation Errors. I know that the procedure executes because I see it putting entries into the database table but the group isn’t getting its output.

This code works fine inside SQL Server Management Studio. Is this possible inside an expression item? Maybe it’s not returning a value fast enough?

`SET NOCOUNT ON
DECLARE @id INT;
EXEC dbo.GetPartID '{[~]Site/3D_Laser_Weld/PartNumber}', {[~]eq_id}, @id OUTPUT
SELECT @id`

Thanks in advance for any help!