sm_iransoftware (2/17/2015)
Thank you allAnd
Thank you David Burrows
I didnot Know Row_Number() Befor this.
Actually ROW_NUMBER was introduced with 2005, you might want to check out the other windowing functions as well, 2014 introduced a few new ones, I'm still on 2008R2 so cannot help you with those.
Far away is close at hand in the images of elsewhere.
Anon.