781
Hello Experts,
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.
*This post is locked for comments
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?
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.
#1
Kempeth
4
#1
Andy Adamak
4
#1
Community Member
4
Share
Report
All responses (
Answers (
