Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • It works great!!... However, query is updating status_state to 'canceled' for all dups. I need at least one record to leave untouched. Any thoughts? I'll see if I can come up with an answer too. Commented Sep 4, 2015 at 19:26
  • Please check the picture I add one row is untouched. Commented Sep 4, 2015 at 19:32
  • Awesome, I fixed the issue. It works flawlessly... Error on my side since both rows had the same transfer_id. Commented Sep 4, 2015 at 19:45
  • Good this work for you. But please next time try to work a litle more in making the question with all the details. Commented Sep 4, 2015 at 19:48