This week I got to write some TSQL and rediscover a neat trick through the magic of reading; specifically reading Inside Microsoft SQL Server 2005: T-SQL Querying.
Working in Sql 2000 I needed to do two things: find the record with the minimum date in a group of records where the dates were not guaranteed to [...]