see this..

DECLARE @Input TABLE

(

Store_Number INT,

Store_Owner VARCHAR(32)

)

INSERT INTO @Input VALUES(542, 'Jaklin Givargidze'), (542, 'Raymond G. Givargidze'), (557, 'Hui Juan Lu'), (557, 'Tong Yu Lu')

SELECT DISTINCT Store_Number,

STUFF((SELECT ','+Store_Owner

FROM @Input S2

WHERE S1.Store_Number = S2.Store_Number

FOR XML PATH('')), 1, 1, '') AS Store_Owner

FROM @Input S1