Thanks Luis. Normally this would be perfect. However, in this case I cannot specify the columns. In one database, there may be 10 dimensions and 10 UDF...

Thanks for the reply Sean. I posted example tables and data in the original message, which is consumable. I did not comment inline but it is...

Hey Jeff, that is a valid question. I realize I did not provide much context to the root of why I posted this question in the first place. ...

Thanks again for the time guys; Sean your answer did the trick. I understand this is completely inefficient and we will be looking at changing the stored procedure which...

Thanks Crazy

I do appreciate the time taken to review and reply to questions. I understand that perhaps I have not articulated the question well enough. I know what...

Wow, thanks fellas, nice replies! I appreciate the time to review and answer the question, err- waste your time with your answers about best practices and odd references to lady...

Thanks for the feedback guys!

@ColdCoffee: Great idea! I had a slight goof-up in my example though. Since we need to capture the YTD values, we would...