Thanks again.
Next question π Can you post your table definitions please? There are some column names in the code that don't match what you originally posted. And, looking at your code there's a backslash in there that doesn't appear in your expected outcome. I'm starting to see what you're trying to achieve but I don't want to make any assumptions and get it wrong.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537