What steps will reproduce the problem? The following SQL statements are all run within the same database connection and cursor: sql = r"SELECT X, Y, Z INTO #temp_table1 FROM mytable WHERE A = ?" ...

Temporary tables can be a powerful tool when working with large datasets. They can help simplify complex queries and improve performance by reducing the amount of data that needs to be processed. 1.

Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL statement to execute. Here's how to speed up your application (and how to simplify your ...

Probably most of the partners have already noticed this and changed the C/AL code accordingly in order to let their customized application works properly. In ALL versions of NAV up to now (NAV 2009 R2 ...