BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20130504T095000Z DTEND:20130504T105000Z LOCATION:SQLBits Conference - Suite 4 SUMMARY:New Analytic Functions in SQL server 2012 DESCRIPTION:In this session I'll be exploring all of the below new analytical functions of SQL server 2012.
CUME_DIST
LEAD  
LAG
FIRST_VALUE
LAST_VALUE
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK

I'll be explaining how this functions works , where we can use these functions. How we were achieving the same in earlier version and now how simple it is to achieve the same.
X-ALT-DESC;FMTTYPE=text/html:

New Analytic Functions in SQL server 2012

In this session I'll be exploring all of the below new analytical functions of SQL server 2012.
CUME_DIST
LEAD  
LAG
FIRST_VALUE
LAST_VALUE
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK

I'll be explaining how this functions works , where we can use these functions. How we were achieving the same in earlier version and now how simple it is to achieve the same.

Sandip Pani

I've more than 5 years of experiance as a SQL/BI developer. I worked in SQL server 2005/ 2008/ 2008R2 and SQL Server 2012. Currently Working for QSI Healthcare (NextGen). Active Memeber of SQLBangalore and BDotNet user groups.

http://sqlcommitted.com UID:SQLBITS1529SEQUENCE:0 DTSTAMP:20130520T182835Z END:VEVENT END:VCALENDAR