In AX 2012, Is there a way to display values from multiple rows in a single column like the way we have in SQL by using 'stuff' and 'for xml path keywords':
https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
In AX 2012, Is there a way to display values from multiple rows in a single column like the way we have in SQL by using 'stuff' and 'for xml path keywords':
https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
No, there is no such thing. It cannot be done using X++ SQL alone.
Feel free to loop around and use a map of sets.