Good Question.

SELECT @t = @t + @comma + a.a

,@comma = ','

FROM #a a

ORDER BY 1

Result : C

SELECT @t = @t + @comma + a.a

,@comma = ','

FROM #a a

ORDER BY a.a

Result : A,A,B,B,C,C

changing the order by giving different result...experts please explain?