# Query Tag With A Stored Procedure Call

**URL:** <https://forum.inductiveautomation.com/t/query-tag-with-a-stored-procedure-call/93102>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [July 11, 2024, 6:47pm UTC](https://forum.inductiveautomation.com/t/query-tag-with-a-stored-procedure-call/93102 "2024-07-11T18:47:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\
**Post date:** [July 11, 2024, 6:47pm UTC](https://forum.inductiveautomation.com/t/query-tag-with-a-stored-procedure-call/93102/1 "2024-07-11T18:47:57Z")

</div>

Can someone please either point me to the documentation for the syntax for stored procedure calls within query tags or help me develop what the correct syntax is? This is for Vision Ignition v8.1.39.

TIA.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 11, 2024, 6:52pm UTC](https://forum.inductiveautomation.com/t/query-tag-with-a-stored-procedure-call/93102/2 "2024-07-11T18:52:06Z")

</div>

There isn't any such support, except via the CALL or EXEC statement of the brand of DB you are using. No support for InOut or Output parameters in such cases, typically.

Consider using a memory tag to hold your result, and drive with a tag change or timer event scripting. Then you can use SP named queries or Ignition's scripted support for parameterized SPs.

(Query and expression tags are not specifically Vision topics, fwiw.)

---

<div class="post-metadata">

**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\
**Post date:** [July 11, 2024, 6:54pm UTC](https://forum.inductiveautomation.com/t/query-tag-with-a-stored-procedure-call/93102/3 "2024-07-11T18:54:47Z")

</div>

> [@pturmel](#):
>
> Consider us

Thanks for the reply. Sounds good, I will try that. I went down this path because in the query tag videos in Induction University said it was possible to do stored procedures for query tags. I didn't know it was so limited.