The T-SQL Cookbook: What's Cool in Microsoft SQL Server 2008 R2 and New in SQL Server Code-Named "Denali"

Sign in to queue

The Discussion

  • User profile image
    Todd Aspeotis

    Looking forward to FIRST_VALUE and LAST_VALUE. I'm confident writing equivalent functionality using ROW_NUMBER() or TOP but our second tier app support guys (who sometimes venture into customer data) have trouble utilising the ranking functions, since ROW_NUMBER()/TOP ventures into subquery/CTE territory.

Add Your 2 Cents