# How do I handle duplicate rows in SQL for grouped transaction data?

**URL:** <https://forum.inductiveautomation.com/t/how-do-i-handle-duplicate-rows-in-sql-for-grouped-transaction-data/98594>\
**Category:** General Discussion\
**Created:** [November 14, 2024, 7:01am UTC](https://forum.inductiveautomation.com/t/how-do-i-handle-duplicate-rows-in-sql-for-grouped-transaction-data/98594 "2024-11-14T07:01:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emmanuel\_Katto2](https://avatars.discourse-cdn.com/v4/letter/e/82dd89/32.png) [@Emmanuel\_Katto2](https://forum.inductiveautomation.com/u/Emmanuel_Katto2)\
**Post date:** [November 14, 2024, 7:01am UTC](https://forum.inductiveautomation.com/t/how-do-i-handle-duplicate-rows-in-sql-for-grouped-transaction-data/98594/1 "2024-11-14T07:01:51Z")

</div>

Hi Everyone I'm Emmanuel Katto from Dubai, I have a transaction group (stored procedure) running, and every time I trigger it, I notice the `#executions` count increases by 1 in the Ignition Designer. However, I end up with two new rows of SQL data, which have almost identical timestamps. Does anyone know what could be causing this?

Regards  
**Emmanuel Katto**

---

<div class="post-metadata">

**Author:** ![Samuel\_Sueur](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@Samuel\_Sueur](https://forum.inductiveautomation.com/u/Samuel_Sueur)\
**Post date:** [November 14, 2024, 7:48am UTC](https://forum.inductiveautomation.com/t/how-do-i-handle-duplicate-rows-in-sql-for-grouped-transaction-data/98594/2 "2024-11-14T07:48:23Z")

</div>

Without providing code or at least the stored procedure, we won't be able to help much I'm afraid.

Also, perhaps I'm the only one bothered by it, but why do you always add your name and location in each of your topic's title ?...

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 14, 2024, 12:06pm UTC](https://forum.inductiveautomation.com/t/how-do-i-handle-duplicate-rows-in-sql-for-grouped-transaction-data/98594/3 "2024-11-14T12:06:41Z")

</div>

Emmanuel, please read the [Keep it Tidy](https://forum.inductiveautomation.com/faq#keep-tidy) section of the FAQ. It particularly requests that you don't sign your posts as your username, etc., is automatically added to the top of each post. If you want to tell people you are from Dubai then add that information to your user profile.

The FAQ doesn't mention adding your name to the title of every post - most likely - because nobody dreamed that someone would do it.

There is an edit link below your post so you can fix it.