http://it.toolbox.com/blogs/data-ruminations/sql-server-2012-equivalent-to-first_value-ignore-nulls-76041