Hi,

Try with query

update table_1 set Comments = SUBSTRING((select ', '+ Comments from table_1 itable

where itable.RatingID = otable.RatingID and Parameter_Order!=0 for xml path('')),3,1000)

from table_1 otable where Parameter_Order =0