# Data cleanse mssql tag historian

**URL:** <https://forum.inductiveautomation.com/t/data-cleanse-mssql-tag-historian/45245>\
**Category:** Ignition\
**Tags:** perspective, database, ignition80\
**Created:** [April 3, 2021, 7:14pm UTC](https://forum.inductiveautomation.com/t/data-cleanse-mssql-tag-historian/45245 "2021-04-03T19:14:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\
**Post date:** [April 3, 2021, 7:14pm UTC](https://forum.inductiveautomation.com/t/data-cleanse-mssql-tag-historian/45245/1 "2021-04-03T19:14:00Z")

</div>

Is there a perspective component or a way for an ignition user to add, delete, change values or rows in SQL? Sometimes our line operators might double enter a transaction or might select a wrong entry which gets recorded. I have perspective table pulling last 50 records from a named query, but I am not sure how to use a update query and make one of the cells editable without making another dataset and table. I would like to change the last record Actual=51 to Actual=52.

 ![table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6bdff8981c772bda80651d3bb01d62e0e02e289f.png)

---

<div class="post-metadata">

**Author:** ![jay.meinke](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jay.meinke](https://forum.inductiveautomation.com/u/jay.meinke)\
**Post date:** [April 5, 2021, 1:37pm UTC](https://forum.inductiveautomation.com/t/data-cleanse-mssql-tag-historian/45245/2 "2021-04-05T13:37:52Z")

</div>

This will work, but the code is for Vision-Power Table. [Editing Multi-Selected Rows from a Table - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)](https://docs.inductiveautomation.com/display/DOC81/Editing+Multi-Selected+Rows+from+a+Table)