I need to take off at the moment, but I'll check back and try to elaborate later.
Notice the location of the subqueries in the example from earlier. The subquery set is after the FROM, not part of the SELECT. You can choose as many columns as you want when done this way. You're basically...
You had said the nested selects are 'hard-coded', but you have power to change the code, correct? I believe there's a fair amount you can do to make this code easier to handle... If you can change the code itself, I think we could make your life much easier. Is it safe to assume this is...
