Analytical functions available in SQL 2005
-
bill leferink (11/11/2013)
I found this link to SS 2005 Ranking functions:http://technet.microsoft.com/en-us/library/ms189798%28v=sql.90%29.aspx
So that one is in both places. Well found. I wonder why I couldn't find it.
Tom
-
Ed Wagner (11/11/2013)
Some of us are still there. :hehe:And it's sometimes very tough to work on 2005 when you spend lot of time with 2008 onwards.
-
so easy....
-
good question .. thanks for sharing
-
We jumped from 2000 to 2008 as well except we did have a test server years ago that was 2005 and I recalled first playing with row_number and ntile then. Had to think a bit to be sure on this one. Thanks!
-
Nice question. Even more interesting name change of the question Author. Wonder what is causing that?! :w00t:
Didn't they call these the Ranking Functions in SQL server 2005?
It's a rhetorical question because they did.
http://msdn.microsoft.com/en-us/library/fooe7f917ba-bf4a-4fe0-b342-a91bcf88a71b.aspx
The link above is to the SQL 2005 Ranking Functions documentation.
-
2008R2 yet, so eliminating un usable functions in 2008R2 give an easy answer for 2005
Thxs
Viewing 7 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply