Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I've got an SQL query like below. I've to write an X++ Query for this and insert the result records in a Table. Here i can convert the SQL to X++ except the "Left Outer Join". In X++ we have "Outer Join" That too is not working with Insert_Recordset. Any suggestion would be helpful.
You can use outer join in AX for the same result.
Instead of Insert_Recordset, you can use RecordInsertList, in a while loop (executes slower in comparison, but quite effective)
Hi Crispin John Augustine,
Thank you for the quick response. Actually i showed a part of the sql query in the image, but this SQL query having four part like this and everything as a same query with Multiple Joins and Union. So if i use the While Statement then it will be "performance issue" though we use RecordInsertList. So can we have any other effective approach? without using While statement.
I can think of one last Option:
* Use the query in a View
* Try reading from the view and use it with insert_recordset. It might work.
Hi Crispin John Augustine,
Sorry for the delayed reply, Since i was working with other priorities i was unable to look into this. Now I've done this task with 'RecordInsertList' and by using AOT Query.Its working fine. Thank you for your valuable suggestions.
One question: Can we implement Direct SQL statement execution in DAX with the given SQL Query. Since i used that before for one customization, it was working fine. So my Question is
# Is this Microsoft best practice? or
# if it comes under MBP then any Performance issue will be there compared to our X++ converted ? or
# we need to convert like what I've done now?
"...Can we implement Direct SQL statement execution in DAX with the given SQL Query..." Short answer - Yes. www.artofcreation.be/.../executing-direct-sql-statements
But this requires line by line processing in AX, which is very bad Performance wise.
But if you are thinking in that direction, you can execute a SQL stored procedure /call from AX, fill an AX table from the sp. community.dynamics.com/.../execute-or-call-sql-stored-procedure-in-axapta-by-code
Once it is done, you can just use RecordList to move this data to your target table.
Business Applications communities