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.
- Please do not vote for the same download more than once.
- Please be objective, if everyone receives 1 or 5 stars, the ratings aren't very useful.
- Do not vote for your own resource or a competitor's.