Adding row numbers to an SQL select result set

row_number() I have always loved SQL as a language, it’s so elegant – most of the time anyway. Since SQL Server 2008 there has been a new function that returns a row number added to an sql select result set that I didn’t discover until very recently. It came about because I was writing a new sql select query Read more about Adding row numbers to an SQL select result set[…]