How to distinct data by command

neramit · 2005-11-17

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

Marije_Brummel · 2005-11-17

What do you mean with duplicate records?

What is it you are trieing to do?

:? :roll:

neramit · 2005-11-17

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 · 2005-11-17

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 · 2005-11-17

Thank You

DenSter · 2005-11-17

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

Marije_Brummel · 2005-11-17

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 · 2005-11-17

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 · 2005-11-17

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

How to distinct data by command

Comments

Categories