Another must-read:
Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
This book will give you a very solid understanding of the new windowing functions in SQL Server 2012.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP