Inner Join TOP 1 Value

Try the CTE approach:

http://www.sqlusa.com/bestpractices2005/cte/

http://msdn.microsoft.com/en-us/library/ms190766(v=sql.105).aspx

You can define multiple CTE-s at the beginning of the query.

---

Kalman Toth Database & OLAP Architect sqlusa.com

New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012