No, the oraclemts service did not stop running and we have Oracle 11.2.0

Thanks.

I did try this code and it somewhat worked.

DECLARE @attach varchar(15)

DECLARE @list varchar(8000)

select @attach=attachid,

@list=program_id_name + ',' + COALESCE(@list,'')

from #t1

SELECT LEFT(@attach,LEN(@attach))as attachid, LEFT(@list,LEN(@list)-1)as progname

However, it took all of the program_id_names...

I did try it, but it did fail. It came with a error for incorrect syntax at FOR XML Path.

Thanks for trying to help.

I understand, however, I work for the state and at this point in time, I do not have access to any other versions. There is talk of upgrading after...