Ok, that is reassuring to know. Not sure what path I am going to take with this as it is still in the concept stage.

Thanks for the reply.

Jason.

Thanks to all those who replied.

bitbucket-25253, I would like to give you more but two of the four are not actual tables exactly. One is a call to...

LutzM.

Thank you very much for the reply. After some investigation I believe combining both computed column and output to retrieve the newly computed "name" in theory should work very...

Yep, your right. After trying - I found that I can't. I looked at wrapping this up in a Table Valued UDF but something put me off the...

Works like a charm.

Thanks again.

Jason.

I am suitably impressed. Really.

Thank you very much for both replies. Absolutely magic. I suspect you have saved me a lot of time.

I feel this approach will...

Yes - that is a very good summary. 🙂

I am relatively new to SQL so your example does not immediately make sense to me. In general it looks...