# Inserting data from a Power table into SQL database table

**URL:** <https://forum.inductiveautomation.com/t/inserting-data-from-a-power-table-into-sql-database-table/69070>\
**Category:** Ignition\
**Created:** [January 27, 2023, 2:11am UTC](https://forum.inductiveautomation.com/t/inserting-data-from-a-power-table-into-sql-database-table/69070 "2023-01-27T02:11:50Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [January 27, 2023, 3:04am UTC](https://forum.inductiveautomation.com/t/inserting-data-from-a-power-table-into-sql-database-table/69070/5 "2023-01-27T03:04:09Z")

</div>

> [@cole.sharrah](#):
>
> This is the shared script compiling the data. Global Script:  
> [Shared Script Systems Overview.txt](https://forum.inductiveautomation.com/uploads/short-url/wMkehstCx9rEYpnGdl4MfdQFCEN.txt) (30.7 KB)
> 
> This is the binding on the data property of the power table.  
> [Systems Overview Data Binding.txt](https://forum.inductiveautomation.com/uploads/short-url/t9h2dXK3IlmfFgEMCziO9o8z7yQ.txt) (1.2 KB)

Ew!

All this to display the most recent values of tags?

Are the tags arranged in folders with identical inner tag names? (Or UDTs, which have the same effect?)

If so, a template that displays one row of tag values, using indirect binding, arranged in a template repeater, would be far more performant. With no SQL at all. (The template repeater would be set to dataset mode, and that dataset's one column would have the necessary tagpath strings.)

---

_[View the full topic](https://forum.inductiveautomation.com/t/inserting-data-from-a-power-table-into-sql-database-table/69070)._