the method above is useful since its dynamic, but i wanted to show you a more manual way of doing it as well.

CREATE taBLE #TEMP

(

id INT,

fk_id INT,

value VARCHAR(10)

)

INSERT INTO #TEMP

VALUES(1, 100, 'Blue'),

(2, 100, 'Black'),

(3, 100, 'Green'),

(4, 101, 'Blue'),

(5, 101, 'Green'),

(6, 102, 'Black')

SELECT FK_ID, REPLACE(REPLACE(RTRIM(LTRIM(COALESCE(Blue ,'') +' '+ COALESCE(Black,'') +' '+ COALESCE(Green ,''))),' ',','),',,',',')AS VALUESS

FROM(

select fk_id, MIN(case when value = 'Blue' then 'Blue' END) Blue,MIN(case when value = 'Black' then 'Black' END) black, MIN(case when value = 'Green' then 'Green' END)Green

from #TEMP

group by fk_id)I