CREATE TABLE #Temp(VIN INT, Description VARCHAR(10),ImagePath NVARCHAR(50));
INSERT INTO #Temp(VIN,Description,ImagePath)
VALUES
(123 ,'Fender','C:\123\Image1.jpg'),
(123 ,'Fender','C:\123\Image2.jpg'),
(123 ,'Fender','C:\123\Image3.jpg'),
(124 ,'Hood',' C:\124\Image1.jpg');
SELECT
DISTINCT VIN
,Description,
STUFF(
(select ','+ImagePath from #TEMP AS T1
where T1.VIN=T2.VIN FOR XML PATH(''),type
).value('.','NVARCHAR(100)'),1,1,'') AS ImagePath
FROM #TEMP AS T2;
OUTPUT:-
VIN | Description | ImagePath
123 Fender C:\123\Image1.jpg,C:\123\Image2.jpg,C:\123\Image3.jpg
124 Hood C:\124\Image1.jpg