Skip to content
(+40)732-833-213[email protected]
Search:
Search
Facebook page opens in new windowLinkedin page opens in new window
Andrei Lungu
Nav Erp Development
Andrei Lungu
  • Home
  • Sample Projects
  • About me
  • Home
  • Sample Projects
  • About me

Tag Archives: SQL

Multicolumn OR filter in MS Dynamics NAV / Business Central

Business Central, Microsoft Dynamics NAVBy AndreiMay 28, 2019Leave a comment

So, you need to retrieve from the database all customers with the Name = ‘John’ OR the Email = ‘[email protected]’ in order to make something with each record from the resulting dataset. In other words you need to use a Multicolumn OR filter. What is the best way to do this in NAV? Please do…

Share
Tweet
Pin
Share
0 Shares

Count the Number of Records in NAV/Business Central

Business Central, Microsoft Dynamics NAV, NAV ALBy AndreiFebruary 12, 2019Leave a comment

Vjeko, wrote some very good posts about the bad performance of COUNT function used in Microsoft Dynamics NAV. You can check them out at the end of this post. COUNT function can be used in NAV to find out how many records with certain filters you have in the database. Let’s take a simple example…

Share
Tweet
Pin
Share
0 Shares

Access SQL Multi-User App- Overtime Tracker

Sample ProjectsBy AndreiFebruary 11, 2016Leave a comment

The Overtime Tracker is an application developed in Access 2013. It was designed to store and analyze the Overtime hours submitted and compensated by the employees of one client. This app can be modified and in the real environment it is updated with more modules and features in order to satisfy multiple needs of the HR…

Share
Tweet
Pin
Share
0 Shares

How to start creating a C# application with SQL Server Database [PART 2]

ApplicationsBy AndreiAugust 25, 20152 Comments

The part 2 of the post which shows how to create a simple application with Windows Forms interface and SQL Server Database

Share
Tweet
Pin
Share
0 Shares

How to start creating a C# application with SQL Server Database [PART 1]

ApplicationsBy AndreiAugust 13, 2015Leave a comment

A very easy tutorial about how to create in Visual Studio and SQL Server a simple application

Share
Tweet
Pin
Share
0 Shares

Developed by Mircea

Go to Top