but If I had to add CTE and temp table I could have done this ,Can you suggest any simple way to just add a third column and show split values separated by comma for second column in that...
Thanks
[font="Comic Sans MS"] ---------------------------------------------------