# SQLBridge Update Multiple Rows **URL:** \ **Category:** Ignition\ **Created:** [November 19, 2018, 5:03pm UTC](https://forum.inductiveautomation.com/t/sqlbridge-update-multiple-rows/20946 "2018-11-19T17:03:34Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![BillS](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@BillS](https://forum.inductiveautomation.com/u/BillS)\ **Post date:** [November 19, 2018, 5:03pm UTC](https://forum.inductiveautomation.com/t/sqlbridge-update-multiple-rows/20946/1 "2018-11-19T17:03:34Z")
Hello, We are beginning to utilize the Transaction Groups provided by SQLBridge and have run into a requirement that I’m hoping can be simplified… We have an array of UDT’s that map to rows in the database… UDT[0].value1 --\> DB\_Table ( idx, value1 ) Value (1, value1) UDT[0].value2 --\> DB\_Table ( idx, value2 ) Value (1, value2) UDT[1].value1 --\> DB\_Table ( idx, value1 ) Value (2, value1) UDT[1].value2 --\> DB\_Table ( idx, value2 ) Value (2, value2) and so on. This update needs to happen for all UDT’s when triggered We also in a different transaction group(different trigger) need to go the opposite way. I am really hoping that I don’t have to do 800 separate transaction groups to accomplish this… Can anybody tell me a simpler way to accomplish this with SQLBridge? I already have a fair idea how I could do it with a Tag Change trigger, but was wanting to see if SQLBridge can do this since this kind of thing is why we purchased the module for this project rather than just doing tag change handlers for everything as we’ve done before. Thank you, Bill ---
**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:** [November 19, 2018, 6:41pm UTC](https://forum.inductiveautomation.com/t/sqlbridge-update-multiple-rows/20946/2 "2018-11-19T18:41:45Z")
The “[Block](https://docs.inductiveautomation.com/display/DOC79/Types+of+Groups#TypesofGroups-BlockGroup)” type of transaction group is what you are looking for. ---
**Author:** ![BillS](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@BillS](https://forum.inductiveautomation.com/u/BillS)\ **Post date:** [November 19, 2018, 8:02pm UTC](https://forum.inductiveautomation.com/t/sqlbridge-update-multiple-rows/20946/3 "2018-11-19T20:02:16Z")
Thanks for the quick reply! I’ll look closer at that type.