As you might know MSDyn365FO’s data access layer pretty different from T-SQL. This means that if you copy a query on AX and paste it in SSMS it won’t validate in the 99% of the cases (the other 1% being a select * from table).
The differences are specially obvious in the join clauses, for example in AX’s (not) exists join which translates to T-SQL as a WHERE NOT EXISTS (SELECT statement).
To…
Continue Reading Adrià Ariste Santacreu’s Article on their blog
Get the T-SQL query from X++
As you might know MSDyn365FO’s data access layer pretty different from T-SQL. This means that if you copy a query on AX and paste it in SSMS it won’t validate in the 99% of the cases (the other 1% being a select * from table).
Blog Syndicated with Adrià Ariste Santacreu’s Permission
More About This Author
Array
- Finance & Operations19 March 2024Error querying Synapse Link
- Finance & Operations22 February 2024Azure Key Vault support in ISVLicenseGenerator v0.7
- Finance & Operations15 January 2024I wrote a book! Extending Dynamics 365 Finance and Operations Apps with Power Platform
- Finance & Operations14 December 2023Microsoft Dev Box and Dynamics 365 F&O local development