This content has been marked as final. Show 2 replies
It is usually better to do it on QV. This way you will not impact the performance of the SQL server.
Instead of using joins try using Mapping Load and ApplyMap(). It is way faster than doing joins and for your example it works perfectly: