Hi EveryOne,

I have a table like this and wanna to distinct some columns so that only one
record will show for this criteria
(User1 <> User2 AND User1SampleNo <> User2SampleNo)



User1       User1SampleNo User2       User2SampleNo EuclideanDistance
----------- ------------- ----------- ------------- ---------------------------------------
1           1             1           1             0.0000000
1           1             1           2             1.6366812
1           1             1           3             3.7507731
1           1             1           4             2.5621797
1           1             1           5             2.5280885
1           2             1           1             1.6366812
1           2             1           2             0.0000000
1           2             1           3             2.9923197
1           2             1           4             2.1335549
1           2             1           5             2.4842911


Any hints?

Thx for your kindest help
Norton

[attached file: Result.rpt]

Subquery performance concern
A query runs 1 times slower from a .NET application the from Query Analizer
Help with varchar to date
schedule dts at a remote server
can a SELECT return this result ?!