# Stored Procedure Transaction Group - reference subset of SP parameters

**URL:** <https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-reference-subset-of-sp-parameters/43059>\
**Category:** Ignition\
**Tags:** database\
**Created:** [February 5, 2021, 9:22am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-reference-subset-of-sp-parameters/43059 "2021-02-05T09:22:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dnord](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@dnord](https://forum.inductiveautomation.com/u/dnord)\
**Post date:** [February 5, 2021, 9:22am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-reference-subset-of-sp-parameters/43059/1 "2021-02-05T09:22:56Z")

</div>

I would like to reference just a subset of the SQL Server SP parameters, but SQL Bridge don’t allow me to. If at least one SP parameter isn’t referenced by the Transaction Group Items, the error “index is out of range” is returned during group execution.

![2021-02-04 13_30_44-Thu Feb 04 09_51_52 CET 2021](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/3452df5e4b0f010f6a709b4713b228c40e369c8b.jpeg)

Today I’m getting around this by creating a tag reference item for each unused parameter. Is there a better way?

I’m running Ignition 8.0.14 on Windows Server 2016. The DB server is a SQL Server 2016.

---

<div class="post-metadata">

**Author:** ![dnord](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@dnord](https://forum.inductiveautomation.com/u/dnord)\
**Post date:** [March 1, 2021, 7:32am UTC](https://forum.inductiveautomation.com/t/stored-procedure-transaction-group-reference-subset-of-sp-parameters/43059/2 "2021-03-01T07:32:26Z")

</div>

It turned out to be a long-standing [open issue](https://github.com/microsoft/mssql-jdbc/issues/553) with the official mssql-jdbc driver. I solved my problem by switching to [jTDS](http://jtds.sourceforge.net/).