Home Forums SQL Server 2008 T-SQL (SS2K8) Get distinct values into single column RE: Get distinct values into single column
buddy__a
Hall of Fame
Points: 3222
More actions
February 20, 2013 at 11:56 am
#1589681
One possible modification that you might want to make is to change this:
d2.Color AS [text()]
to this:
d2.Color AS [data()]
That way your items would have a space between them instead of being run together in a continuous string.