The solution is to convert these types of stored procedures to table valued functions. Jamie Thomson wrote a nice article about this very problem in 2006 which has now...