# SQL query tag addressing

**URL:** <https://forum.inductiveautomation.com/t/sql-query-tag-addressing/80216>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [October 9, 2023, 5:36pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-addressing/80216 "2023-10-09T17:36:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [October 9, 2023, 5:36pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-addressing/80216/1 "2023-10-09T17:36:46Z")

</div>

I have some SQL query tags, I store the result as Dataset, the I use them in the Vision Windows as in the image below (dataset address).

Is this the "right" recommended way to use them or should assign the dataset individual addresses to individual specific Memory tags then use them? as example if I read in the Dataset many machine names then assign each of them to an individual memory tag? thinking in the case that the original dataset source may change (and the addresses inside of the dataset will change).

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/c/8cdcc39a2ac71068f7773b23fd0315176c855133.png)

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [October 9, 2023, 7:31pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-addressing/80216/2 "2023-10-09T19:31:38Z")

</div>

I prefer to use an expression so I can wrap it in a try and return a default value if needed, or a blank string

`try({Path/To/DataSet/Tag}[0,'ColumnNameOrIndex'],'')`

---

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [October 9, 2023, 8:25pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-addressing/80216/3 "2023-10-09T20:25:54Z")

</div>

thanks
