# Stored procedure group multiple rows

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-group-multiple-rows/110923>\
**Category:** Ignition\
**Created:** [September 24, 2025, 3:22pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-multiple-rows/110923 "2025-09-24T15:22:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dis](https://avatars.discourse-cdn.com/v4/letter/d/e99b99/32.png) [@dis](https://forum.inductiveautomation.com/u/dis)\
**Post date:** [September 24, 2025, 3:22pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-multiple-rows/110923/1 "2025-09-24T15:22:57Z")

</div>

I am starting to work with SQL-Bridge and I’m building it to facilitate downloading of recipe data to a Controllogix PLC.

I browsed to my PLC to create the initial tag structure (an array of 2 UDTs of which 1 UDT is also an array of a UDT) then converted those tags to memory tags so I can test things. The simplified structure is as follows:

```plaintext
Formula_0_
  Header (folder)
    Tag_1 
    Tag_2
    Tag_3
  Step (folder)
   Step_0_(folder)
       stepNum 
       stepTag_1
       stepTag_2
       stepTag_3
   ...1-39   
    Step_40 (folder)
       stepNum 
       stepTag_1
       stepTag_2
       stepTag_3

```

My stored procedure returns 2 tables. The first table is Header data, 1 row. The 2nd table is the step data 41 rows.

Is there a way for the transaction group to “know” to write each row of the step data to each folder of step tags?

Or would I need to treat each tag in the ‘step’ as block groups?

```python
BlockGroup_0 Write 0-40 stepNum tags
BlockGroup_1 Write 0-40 stepTag_1 tags
BlockGroup_2 Write 0-40 stepTag_2 tags
BlockGroup_3 Write 0-40 stepTag_3 tags
...
BlockGroup_n

```

The issue I have is it doesn’t appear the transaction group can handle multiple rows being returned. I have a feeling this may become a multi-step procedure where I query the Header data and populate some tags. Query the steps to get a row count and save the unique identifier for each row then retrieve each row individually. Or possibly re-organize my tag structure to match the block structure?