Hi all

I see that my thread receives replies from several people, thank you for that.

Kevin sorry for not replying yesterday to your thread, it got kind of late in the Netherlands, that's why.

Maybe a return question: do you need a sql server database/ table with a lot of data in it, or can I collect the data in 1 big Excel sheet with (let's say) 10000 lines?

The last is the most easy, maybe also for you to import the data?

Your other question about sorting: these are speedskating times, so the fastest 1 wins. Therefore I always use Order by Times Asc

The "Between" suggestion gives more results than wanted. There are many different distances, and not al of them are "standard", think about old races where distance are in miles (1.609 meters) or in 1/4 miles etc.

Kevin's guess is correct: I am looking for the top N records in each segment.

BTW the distances I gave/used are meant to be a sample. Beside the 500, 1000 and 1500 there more main-distances like 3000, 5000 and 10000 meters

Besides these distances, sometimes a race track is too long or short, resulting in many different distances (999 m is not 1000m!)

Hein

PS

I have made a new Excel files with 6000 data rows, and I have a SQL Server table with the same data

I am fairly new to this, but how can I upload / attach a table to this thread?