# Changing tag values on a schedule in a SQL table

**URL:** <https://forum.inductiveautomation.com/t/changing-tag-values-on-a-schedule-in-a-sql-table/42169>\
**Category:** Ignition\
**Created:** [January 12, 2021, 6:23pm UTC](https://forum.inductiveautomation.com/t/changing-tag-values-on-a-schedule-in-a-sql-table/42169 "2021-01-12T18:23:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinh.nguyen](https://avatars.discourse-cdn.com/v4/letter/v/e274bd/32.png) [@vinh.nguyen](https://forum.inductiveautomation.com/u/vinh.nguyen)\
**Post date:** [January 12, 2021, 6:23pm UTC](https://forum.inductiveautomation.com/t/changing-tag-values-on-a-schedule-in-a-sql-table/42169/1 "2021-01-12T18:23:23Z")

</div>

I have a SQL table with datetimes and values, I need it so when that date time is passed the tag values will be updated to the corresponding values from the table. What is the best way to approach this without needing to query the database at a high rate.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [January 13, 2021, 5:57pm UTC](https://forum.inductiveautomation.com/t/changing-tag-values-on-a-schedule-in-a-sql-table/42169/2 "2021-01-13T17:57:40Z")

</div>

How often does the SQL Table get updated? One approach would be to use a dataset tag to store the query results, with whatever scripts or transaction groups looking up data from the tag.