Hello,

try this select (this pivots rows to one string row):

select stuff((select top 10 ',"' + code + '"' from Products order by code for XML path('')), 1, 1, '');