How to distinct data by command

neramit

after do setrange command i have many duplicate record
What command do distinct data
anyone know please tell me
](*,)

Marije_Brummel

What do you mean with duplicate records?

What is it you are trieing to do?

:? :roll:

neramit

duplicate mean
Command in SQL
Select Distinct CustomerID from Orders'
In navision have function or command to do Yes/No

i want to select once data if duplicate
Exsample data
item1
item1
item1
item2

result
item1
item2
O:)

Marije_Brummel

I thought/was affraid of you meant this

No, this is no default function in navision.

You can do other things/tricks of course... 8)

neramit

Thank You

DenSter

This is one of the very few things in Navision that I consider an actual shortcoming.

Marije_Brummel

The easiest way to solve it is making a temporary table with the duplicate fields as primairy key fields

Like the posting buffer in cu. 80 & 90.

DenSter

Right, you could fill up a temporary Customer variable by looping through the sales line table, and there are probably 10000 other ways to do this, like marking the records or using some code to skip records. It would be so much easier though if we had the DISTINCT keyword, that should be available in every DBMS. Especially when you consider that the Navision backend can be SQL Server, but we can't use its potential to the fullest.

Marije_Brummel

https://mbs.microsoft.com/partnersource ... suggestion