Linking to the Previous Row is actually really useful, showing a practical and elegant example of partitions, common table expressions, and row_number() functions in SQL Server 2005, to enable straightforward JOINs to previous and next rows. This type of query could prove very useful for Tim 🙂