>>What is the easiest way to select the first record based on a single field?
>
>See SELECT TOP 1 ...
I should have given a better explanation of what I am looking for.
If I have several records for companyA and several records for companyB and several for companyC, what is the easiest way to select the first record for each company?
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).