The new Analytic functions in SQL Server 2012

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Wayne Sheffield » The new Analytic functions in SQL Server 2012...

26 posts, Page 3 of 3

«««1 2 3

The new Analytic functions in SQL Server 2012

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Friday, January 20, 2012 9:56 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:41 PM
Points: 33,108, Visits: 27,032

Wonderful article, Wayne. The charts summarize a nicely laid out and well written article and make it real easy to get extra information. Thanks for taking the time to write a class article!

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1239599

Gabe T.

Posted Saturday, January 21, 2012 4:24 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 1:46 PM
Points: 40, Visits: 138

Now if only we could get 2012 on our production boxes before 2020. So excited for SS2012

Post #1239874

spaghettidba

Posted Sunday, January 22, 2012 4:58 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 4,804, Visits: 8,091

Great article Wayne!
Thanks for sharing.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1239970

Koen Verbeeck

Posted Tuesday, January 24, 2012 6:01 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495

Great article Wayne, thanks.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1240802

zombieisdead2020

Posted Tuesday, January 29, 2013 12:07 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 5:29 AM
Points: 18, Visits: 66

I see first_value and last_value function, but do not see second or third value function!
How can I write for example second_value() function by using analytical window function?

Post #1413231

WayneS

Posted Tuesday, January 29, 2013 9:29 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 6,386, Visits: 8,285

zombieisdead2020 (1/29/2013)

I see first_value and last_value function, but do not see second or third value function!
How can I write for example second_value() function by using analytical window function?

You will probably have to revert to the ROW_NUMBER() function, then look for where ROW_NUMBER() = 2, 3, etc.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #1413429

« Prev Topic | Next Topic »

26 posts, Page 3 of 3

«««1 2 3

Permissions