six I are convinced in first question you've got shared variable among outer query and subquery, so For each and every row in most important question, subquery executes but in second just one the subquery only executes just one time which way general performance improved. I labored on all SQL Server variations (2008, 2008R2, 2012, 2014 and 2016).