NAV 2013 SQL Query Codeunit Download
Another free utility from Insight Works
For those times when the new Query objects (as good as they are) just aren’t enough and you’re desperate for direct SQL access as a last resort.
Simple codeunit allows you to execute an SQL query to populate any NAV (temporary) table using one call. Test page is included to demonstrate functionality with a simple query. 2013 version does not use COM (all code runs on NST), but zip file also includes COM version for pre-R2 NAV.
Note that users will be required to have select access to the tables in SQL Server to run this code.
File size: 37.1 kb