Jeg benytter MSDE MSSQL
Denne viser alle der er en af:
------------------------------------
Select A. <Felt xx>, (Select Count(B.<Felt xx>) from <<Tabel>> as B Where B. <Felt xx>=A. <Felt xx>) as antal
From <<Tabel>> As A
Where (Select Count(B. <Felt xx>) from Vejning as B Where B. <Felt xx>=A. <Felt xx>)=1
Group by A.VognmandsNr
Denne Sletter alle der er en af
Undskyld den er lidt langhåret
------------------------------------
While (Select top 1 (Select Count(b. <Felt xx>) from <<Tabel>> as B Where B. <Felt xx>=A. <Felt xx>) as antal
From <<Tabel>> As A
Where (Select Count(B. <Felt xx>) from <<Tabel>> as B Where B. <Felt xx>=A. <Felt xx>)=1
Group by A. <Felt xx>)>0
Begin
Delete
From <<Tabel>>
Where <Felt xx>=(Select Top 1 <Felt xx>
From <<Tabel>> as A
Where (Select Top 1 Count(B. <Felt xx>)
From <<Tabel>> as B
Where A. <Felt xx>=B. <Felt xx>
Group by A. <Felt xx>)=1)
end
MV.
Peter Jensen