Hello.

I'm used this one, without cursor:

declare @sep varchar(1)

declare @text varchar(max)

set @sep=''

select @text=@text + @sep + column1, @sep=',' from table

Modification for distinct version was shown: replace table by (select distinct column1...

What's about this question?

In SQL 2000 - CharIndex is nondeterministic

http://msdn.microsoft.com/en-us/library/aa214775(SQL.80).aspx

In SQL 2005 - CharIndex is deterministic

http://msdn.microsoft.com/en-us/library/ms178091(SQL.90).aspx

Sorry, but question didn't precise about which version sql server was...

So, I answered correct but false. Who will apologize to me ? 😉