Having posted last night about row numbers and ranking, I realised in the shower this morning that there’s actually an easy way to get the first and last rows per group, just by using ROW_NUMBER. The trick is to PARTITION, … Continue reading →

Sometimes things pass you by. I’ve been using the ROW_NUMBER() function SQL Server 2005 for ages, along with Common Table Expressions, to do server side paging, but had completely missed some other new functions. This is an odd occurrence for … Continue reading →