This is very closed to what I was looking for. You definitely took care of the multiple usernames associated to the Filteruser tag. But ideally, I would like keep the...

Thanks guys,

Thanks for taking the time to review my request. Sorry for not displaying more descriptive data. Below is the modified data that i used to produce the table (select...

:crying: Sorry for my ignorance... You guys have laid down the answer for me... This thread can be close. Thanks for the quick response.

You guys are geniuses!! It does work as both of you have demonstrated with this fictitious scenario. However I have a little problem as I misrepresented a piece of...

Thank you to both of you guys. You have saved me so much time. By the way I am not all that verse with SQL. Was the method that you...

Thanks Dwain.c for looking into it. Your answer as laid out works great but then I run into more problems as I work my way down the XML file.

DECLARE