# Stored Procedure Group how to (7.2.8)

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-group-how-to-7-2-8/3254>\
**Category:** Ignition\
**Created:** [September 6, 2011, 5:27pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-how-to-7-2-8/3254 "2011-09-06T17:27:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [September 6, 2011, 5:27pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-how-to-7-2-8/3254/1 "2011-09-06T17:27:34Z")

</div>

Hello,

I’ve a simple table with ID, Name, Lastname.  
A stored procedure, working correctly (MySQL).  
I just want to pass a parameter (firstname) to retrieve the output of the Stored Procedure in another SQL Tag using a Stored Procedure Transcation Group.

Can someone guide me ?

```auto
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`employee` $$
CREATE PROCEDURE `employee`(IN prenom VARCHAR(255))
BEGIN
SELECT lastname
	    FROM employee
	    WHERE firstname = prenom;
END $$
DELIMITER ;
```

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [September 6, 2011, 6:01pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-how-to-7-2-8/3254/2 "2011-09-06T18:01:40Z")

</div>

Sure, just create a stored procedure group. On the Action tab on the right hand side simply select the employee stored procedure from the dropdown list. Once you have that drag in the tag you want to write to. You can right click on the item and press edit. Map that item as the return value from your stored procedure. Let us know if you have any issues.