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!