Jeff Moden (6/26/2011)
As a side bar, you might want to avoid using ORDER BY X where X is an integer.. . . and, second, it's been deprecated. 😉
Jeff,
Can you cite a reference for this? According to the 2008 R2 docs, you can still use it unless using a ranking function. TIA