As many of you know, using temporary tables in Microsoft Dynamics NAV is a very powerfull feature. We can use it to buffer data, to simulate SELECT DISTINCT etc. And they are free.
Using temporary tables becomes even more powerfull when adding an array to it. Let’s see this in an example.