IDENTITY() Function Isn’t Reliable for Imposing Order on a Result Set

(Brian Moran) T-SQL is a powerful tool, but it doesn’t provide native language constructs to do all the operations you need to do, such as creating rank within a result set. I’m not going to describe how to impose order within a result set (read Itzik Ben-Gan’s T-SQL 2005 column “Ranking Functio

Read More - Register for Free Membership