# Dynamic Sql Query

**URL:** <https://forum.inductiveautomation.com/t/dynamic-sql-query/12447>\
**Category:** Ignition\
**Created:** [December 8, 2016, 9:15pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql-query/12447 "2016-12-08T21:15:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dturner](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dturner](https://forum.inductiveautomation.com/u/dturner)\
**Post date:** [December 8, 2016, 9:15pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql-query/12447/1 "2016-12-08T21:15:17Z")

</div>

I am using a SQL query tag in my UDT and I am trying to use two parameters, Line\_Name and Machine, in the Select statement. Using the parameters does not yield a value but using the actual tag or value does. The query below shows what I am trying to do. Is my syntax correct? Am I trying to do something that cannot be done this way?

```auto
Select 500 - Sum(Actual*{[~]{Line_Name}/{Machine_Name}/Remaining_Wire})
From EOSData
Where EOSDate > '{[Weld]{Line_Name}/{Machine_Name}/Latest_Drum_Change_Out_Date}'
```

---

<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:** [December 9, 2016, 12:59pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql-query/12447/2 "2016-12-09T12:59:07Z")

</div>

You cannot nest brace substitutions. You’ll have to make an expression that assembles the nested part, then put that in your SQL.

---

<div class="post-metadata">

**Author:** ![AFULLER](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/afuller/32/7931_2.png) [@AFULLER](https://forum.inductiveautomation.com/u/AFULLER)\
**Post date:** [March 2, 2021, 9:24pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql-query/12447/3 "2021-03-02T21:24:48Z")

</div>

Can you post a link for this?