Tag Archives: Sql

How to make an optimized query using direct SQL statements in X++.

In this post we are going  to show you how to achieve this. As a first step we are going to create a new class and  we will proceed as always declaring the variables we are going to use.

Query at Dynamics table in C# from a SQL DataBase.

Create a new project in C#.

Macros in SQL statements.

One of the benefits to use Macros, is that it allows to specify  partial statements on X++ querry code, that can be reused in several parts along any application.