Try this:
SELECT DISTINCT
STUFF((SELECT ',' + m2.Region
FROM #Table_1 AS m2
WHERE m2.Prop1 = m1.Prop1
AND m2.Prop2 = m1.Prop2
AND m2.Prop3 = m1.Prop3
ORDER BY m2.Region
FOR XML PATH('')),1,1,'') AS Regions
,m1.Prop1
,m1.Prop2
,m1.Prop3
FROM #Table_1 AS m1
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]