# SQL SProc to list of OPC tags (UDTs)

**URL:** <https://forum.inductiveautomation.com/t/sql-sproc-to-list-of-opc-tags-udts/19475>\
**Category:** Ignition\
**Created:** [August 30, 2018, 10:13pm UTC](https://forum.inductiveautomation.com/t/sql-sproc-to-list-of-opc-tags-udts/19475 "2018-08-30T22:13:39Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![a.ansari](https://avatars.discourse-cdn.com/v4/letter/a/6de8d8/32.png) [@a.ansari](https://forum.inductiveautomation.com/u/a.ansari)\
**Post date:** [August 30, 2018, 10:13pm UTC](https://forum.inductiveautomation.com/t/sql-sproc-to-list-of-opc-tags-udts/19475/1 "2018-08-30T22:13:40Z")

</div>

Hello All. I need to load some data into OPC tags that is returned as a selection from a stored proc. The StoredProc returns a resultset of multiple rows with colums (Ingredient, Instruction, Source, Destination, targetSetPoint). Please note, these are not output parameters. How can I utilize a Stored Procedure Transaction group to map to OPC tags? Ideally, I would like to map each row to a UDT.

So far I can select multiple rows into tags via Block Group, but it can only use one table and one column. It also cannot map to UDT.