Select TOP 1 not being respected in Inner query

[daryllabar]

Was trying to cleanup some duplicate records.

Ran this query:

Then went and attempted to deactivate the first duplicate record with this query:

but as you can see, it updated 2 records, rather than one. Looks to only be an issue with Top 1. Top 2 or more worked...

---

• Deployment: Online
• DB Version: 9.2.23122.208
• Connection Controls Version: 1.2023.6.56
• XrmToolBox Version: 1.2023.12.68
• Tool Version: 8.0.0.0

[MarkMpn]

Thanks for the details - I’ve got a fix for this now but it might still be a while until the next release while I’m working on other areas. In the meantime you should get the expected results if you replace IN with = when you only want to update a single record.