In MS-Access, there are two functions that are listed along with the normal aggregate functions. They are FIRST and LAST, and they act just like they sound. If you have a sorted a recordset, FIRST will give you the first record for each break in the "Group By" clause. I've noticed that there isn't a function like this in SQL Server 7. How might this be accomplished in SQL Server 7?
Thanks,
Brian