select
elderlyName=stuff((select ','+elderlyName from T2_Elderly t where Sales=T2_Elderly.Sales for xml path('')), 1, 1, '')
from
elderlyName=stuff((select ','+elderlyName from T2_Elderly t where Sales=T2_Elderly.Sales for xml path('')), 1, 1, '')
from
T2_Elderly
group by Sales