@Lynn Pettis,

There are 'too many' text values for 'Result' column, and in future I might wanna do it for some other tables, I just dont want to keep editing things...so...

Hi @ColdCoffee,

Since the above was not working, I tried a little different approach and now it says that some rows are affected, but also gives an error and so does...

And when I hover over 'service' and '##myTable2' in the following, (it appears in red color) and shows 'invalid column name and object name' respectively.

SELECT @collect_list_service = @collect_list_service...

Hello,

Thanks a lot for your reply. I made the changes according your post. But still this thing doesn't seem to work.

The following is my code, the errors, and a...