November 10, 2013 at 6:06 am
Comments posted to this topic are about the item Analytical functions available in SQL 2005
November 10, 2013 at 12:04 pm
Bah!
November 11, 2013 at 1:36 am
Nice Question, but I dont understand this:
Before answering the question:
Analytical functions available in SQL 2005
By Rob Stebbens, 2013/11/08
And after answering the question:
Analytical functions available in SQL 2005
By Amit Raut, 2013/11/11
:hehe:
Best Regards,
Chris Büttner
November 11, 2013 at 1:53 am
This was removed by the editor as SPAM
November 11, 2013 at 2:59 am
Question from SQL 2005... 🙂
November 11, 2013 at 4:57 am
Simple straightforward question. Useful (while SQL 2005 is still in widespread use) because MS documentation on this is unsatisfactory.
I though the question would be difficult at first, because I skipped from SQL 2000 to SQL 2008 with only a glance at SQL 2005 to determine that it didn't have enough in it to justify the cost of migrating ourselves and all out customers, because I needed developers to sort out the appaling C++ and T-SQL application code, terrifyingly unnormalised schemata, and totally misguided system architecture that I had inherited rather than upgrade to a new MS version, so I didn't remember which of these functions was new in 2008 and which was already in 2005. But then I realised I could approach it the other way - look for the three that were not there, and three of these seven functions weren't in 2008 R2 let alone in 2005, so that gave me the answer. I expected the explanation to provide a nice straightforward reference to something about new features in 2005, but no - it seemed to follow the approach I had used and referenced a list of functions new in SQL 2012; I'm not sure that's a good way to explain this sort of thing, since without the "(Select 4)" in the question that doesn't provide an answer - it doesn't demonstrate that the other 4 functions were actually there - but i gues I shouldn't complain as that's the route I took to the answer; it made me go and check though, and as far as I can tell it is nowhere documented that these 4 functions are additions to T-SQL in 2005; of course each has its own page in Transact-SQL Reference for 2005, but it seems odd that the BOL list of new features makes no mention of them.
Tom
November 11, 2013 at 5:28 am
Nice one... good to recall old days SQL 2005 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 11, 2013 at 5:53 am
Christian Buettner-167247 (11/11/2013)
Nice Question, but I dont understand this:Before answering the question:
Analytical functions available in SQL 2005
By Rob Stebbens, 2013/11/08
And after answering the question:
Analytical functions available in SQL 2005
By Amit Raut, 2013/11/11
:hehe:
Yep; I noticed this also not only for this question, it happened for other questions as well! weird hah. 😉
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
November 11, 2013 at 5:53 am
Some of us are still there. :hehe:
November 11, 2013 at 7:32 am
L' Eomot Inversé (11/11/2013)
... as far as I can tell it is nowhere documented that these 4 functions are additions to T-SQL in 2005; of course each has its own page in Transact-SQL Reference for 2005, but it seems odd that the BOL list of new features makes no mention of them.
Agree with Tom on backward reference. This was the best reference I could find that listed all four together: http://msdn.microsoft.com/en-us/library/fooe7f917ba-bf4a-4fe0-b342-a91bcf88a71b.aspx
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
November 11, 2013 at 8:14 am
Wow! Got it right just by picking the 4 I had actually heard of.
Tony
------------------------------------
Are you suggesting coconuts migrate?
November 11, 2013 at 9:49 am
I sort of did it like Tom
I knew that LAG and LEAD and PERCENT_RANK were all 2012 features (and some of the reasons we wanted 2012).
November 11, 2013 at 12:33 pm
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 11, 2013 at 12:45 pm
It was a "down the memory hole" for me - I have not touched 2005 in almost six years.
Thanks for the question, Amit!
November 11, 2013 at 1:37 pm
Thomas Abraham (11/11/2013)
L' Eomot Inversé (11/11/2013)
... as far as I can tell it is nowhere documented that these 4 functions are additions to T-SQL in 2005; of course each has its own page in Transact-SQL Reference for 2005, but it seems odd that the BOL list of new features makes no mention of them.
Agree with Tom on backward reference. This was the best reference I could find that listed all four together: http://msdn.microsoft.com/en-us/library/fooe7f917ba-bf4a-4fe0-b342-a91bcf88a71b.aspx[/quote]
That's a good reference.
But ... ... I wonder if I'm the only person who finds it irritating that this dom=cumentation is provided only in Windows Server documentation - it's not in SQL Server Product Documentation, so not in Books OnLine. I think Microsoft got this wrong, there's too much stuff that belongs in the Transact-SQL Reference section of BOL that is not there but in the Windows Server documentation instead. Why isn't it in both places?
Tom
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply