On the first sight this seems to be a good candidate for Common Table Expression http://msdn.microsoft.com/en-us/library/ms175972.aspx . Maybe worthy to try.